On 2023-03-13 17:38:51 -0400, Celia McInnis wrote: > I would be really happy if postgresql had an upper case version of the ß > german character. The wiki page > https://en.wikipedia.org/wiki/%C3%9F > > indicates that the capital (U+1E9E ẞ LATIN CAPITAL LETTER SHARP S) was encoded > by ISO 10646 in 2008. The character is there, of course, and lower-casing it works as expected: hjp=> select 'ẞ', lower('ẞ'); ╔══════════╤═══════╗ ║ ?column? │ lower ║ ╟──────────┼───────╢ ║ ẞ │ ß ║ ╚══════════╧═══════╝ (1 row) But the 'ß' is a bit special as it is usually uppercased to 'SS' (although 'ẞ' is now officially allowed, too). Apparently your (and my) locale doesn't uppercase ß at all, which isn't correct according to German spelling rules but was very common in the last decades. You can specify an alternate locale: hjp=> select upper('ß'); ╔═══════╗ ║ upper ║ ╟───────╢ ║ ß ║ ╚═══════╝ (1 row) hjp=> select upper('ß' collate "de-AT-x-icu"); ╔═══════╗ ║ upper ║ ╟───────╢ ║ SS ║ ╚═══════╝ (1 row) The challenge now is to find a locale which uppercases ß to ẞ. hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
