On 9/22/24 09:48, Paul Förster wrote:
Hi Joe
On 22. Sep, 2024, at 15:47, Joe Conway <mail@xxxxxxxxxxxxx> wrote:
Note that moving to ICU might improve things, but there are similar potential issues with ICU as well. The trick there would be to get your OS distro provider to maintain the same ICU version across major versions of the distro, which is not the case currently. Nor does the PGDG repo do that.
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.
Cheers,
Paul
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
