From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org, Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com> |
Subject: | Re: Uppercase version of ß desired |
Date: | 2023-03-13 22:54:43 |
Message-ID: | 2371653.1678748083@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Peter J. Holzer" <hjp-pgsql(at)hjp(dot)at> writes:
> 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.
> 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.
Our code for libc locales doesn't support upcasing 'ß' to 'SS',
because it uses towlower() which can only manage
one-character-to-one-character transformations. It should work for
upcasing to 'ẞ', but as you say, you need to find a locale that thinks
that should happen.
You might have better luck if you have a version of Postgres that
supports ICU and you can use an ICU locale. That code path doesn't
appear to have any hard-wired assumption about how many characters
in convert to how many out.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Clements | 2023-03-14 03:07:02 | Re: Idea: PostgreSQL equivalent to Oracle's KEEP clause |
Previous Message | Peter J. Holzer | 2023-03-13 22:45:05 | Re: Uppercase version of ß desired |