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
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
> 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
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
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
"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
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