Re: Uppercase version of ß desired

2023-03-14 Thread Celia McInnis
Thanks Philip. Certainly interesting, As long as postgresql and python return something different for upper and lower case versions of these letters and python indexing of the string picks out the characters "properly" then it might not require a python fix for me. What a can of worms! But at lea

Re: Uppercase version of ß desired

2023-03-14 Thread Kip Cole
The relevant Unicode reference is https://unicode.org/faq/casemap_charprop.html#11 Which basically says that since Unicode 5.0 (its now at Unicode 15.0) stability is guaranteed and the upper-casing to (U+1E9E ẞ LATIN CAPITAL LETTER SHARP S) is optional. > On 14 Mar 2023, at 9:12 pm, Philip S

Re: Uppercase version of ß desired

2023-03-14 Thread Philip Semanchuk
> On Mar 13, 2023, at 5:38 PM, Celia McInnis wrote: > > HI: > > 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 > e

Re: Uppercase version of ß desired

2023-03-14 Thread Thorsten Glaser
On Tue, 14 Mar 2023, Celia McInnis wrote: >uc_alphabet = lc_alphabet.replace('ß', 'ẞ').upper() That’s probably for the best. The uppercase Eszett was only added to Unicode under the rule that the lowercase Eszett’s case rules are kept unchanged, and the former’s considered normally only ever type

Re: Uppercase version of ß desired

2023-03-13 Thread Celia McInnis
Hmmm. Yes the unicode rules seem to be a little strict on conforming to the past! I just made the following fix to my python code in forming the upper case alphabet from the lower case one: uc_alphabet = lc_alphabet.replace('ß', 'ẞ').upper() So far I have only found German to have a lower case l

Re: Uppercase version of ß desired

2023-03-13 Thread Tom Lane
"Peter J. Holzer" 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). > App

Re: Uppercase version of ß desired

2023-03-13 Thread Peter J. Holzer
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

Uppercase version of ß desired

2023-03-13 Thread Celia McInnis
HI: 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