Re: Collation with upper and numeric comparing in unexpected way

From: Matt Magoffin <postgresql(dot)org(at)msqr(dot)us>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Collation with upper and numeric comparing in unexpected way
Date: 2026-01-21 20:53:56
Message-ID: 7216E909-5C02-469E-A970-41BEDD4B0242@msqr.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 21 Jan 2026, at 8:52 PM, Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:
> This is just my guess from the outside. The numeric sorting is not a part of the Unicode Collation Algorithm standard, it is an extension by ICU, so one would have to dig into the code or documentation there, but I didn't find anything.
>
> I don't know if there is a way to customize this further to get the effect you want. Maybe you could reach out to an ICU support forum to get more expert insights there.

Ah, thank you for your thoughts. I will reach out to the ICU project as you suggest.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2026-01-21 21:40:01 Re: Request for cryptographic mechanisms used in PostgreSQL
Previous Message Laurenz Albe 2026-01-21 18:57:26 Re: pgBadger and postgres_fdw