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

Casting a collation in an ORDER BY ... COLLATE

2022-05-21 Thread Kip Cole
I’m trying to cast a string value to a collation name without success. My suspicion is this isn’t possible based upon the error message. But perhaps wiser heads than mine have a suggestion on how to do this? cldr_sql=# select * from models order by name collate 'en-x-icu'::regcollation; ERROR: s