Re: Sorting by respecting diacritics/accents

2025-07-25 Thread Laurenz Albe
On Fri, 2025-07-25 at 13:05 +0300, JānisE wrote: > I seem to not be able to get PostgreSQL to sort rows by a string column > respecting the diacritics. > > I read [1] that it's possible to define a custom collation having collation > strength "ks" > set to "level2", which would mean that it's a

Sorting by respecting diacritics/accents

2025-07-25 Thread JānisE
Hello! I seem to not be able to get PostgreSQL to sort rows by a string column respecting the diacritics. I read [1] that it's possible to define a custom collation having collation strength "ks" set to "level2", which would mean that it's accent-sensitive. However, when I try to actually sort u