Re: sort order

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sort order
Date: 2021-07-27 17:40:05
Message-ID: 352607.1627407605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Millas <marc(dot)millas(at)mokadb(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2021-07-27 18:32:45 Re: PostgreSQL reference coffee mug
Previous Message Marc Millas 2021-07-27 17:29:14 Re: sort order