Re: sort order - Mailing list pgsql-general

From Tom Lane
Subject Re: sort order
Date
Msg-id 352607.1627407605@sss.pgh.pa.us
Whole thread Raw
In response to Re: sort order  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
Marc Millas <marc.millas@mokadb.com> writes:
> Re-reading my post, I see that even the élise is not sorted correctly on
> w10...

Sort orders aren't even particularly guaranteed on different releases
of the same platform, let alone totally different platforms.  glibc
made major changes to their collation rules not long ago:

https://wiki.postgresql.org/wiki/Locale_data_changes

At one time we thought that migrating to ICU sorting might bring
a little more stability to this, but I think what we've found so
far is that it's just different :-(

            regards, tom lane



pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: Re: sort order
Next
From: Matthias Apitz
Date:
Subject: Re: PostgreSQL reference coffee mug