On 2024-09-22 09:53:58 -0700, Adrian Klaver wrote: > On 9/22/24 09:48, Paul Förster wrote: > > Then I strongly suggest that the PostgreSQL developers develop a > > fail safe sorting mechanism that holds for generations of locale > > changes. > > https://www.postgresql.org/docs/17/release-17.html#RELEASE-17-HIGHLIGHTS > > Add a builtin platform-independent collation provider (Jeff Davis) > > This supports C and C.UTF-8 collations. Couldn't you always use "C" collation? The problem with that is that most people[1] want stuff ordered according to the rules of their language and C collation is in most cases very different. hp [1] I actually have LC_COLLATE=POSIX set in the shell. But I'm not normal. -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@xxxxxx | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment:
signature.asc
Description: PGP signature
