From: Matt Magoffin <postgresql.org@msqr.us>
Message-Id: <7216E909-5C02-469E-A970-41BEDD4B0242@msqr.us>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_179C084A-9FA1-4FFD-A1A9-62D141200EAA"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81.1.4\))
Subject: Re: Collation with upper and numeric comparing in unexpected way
Date: Thu, 22 Jan 2026 09:53:56 +1300
In-Reply-To: <03f1450c-a730-40af-890c-c269db74a8ec@eisentraut.org>
Cc: pgsql-general@lists.postgresql.org
To: Peter Eisentraut <peter@eisentraut.org>
References: <9EBA273E-7F3C-40F4-8156-745A4BB5B090@msqr.us>
 <03f1450c-a730-40af-890c-c269db74a8ec@eisentraut.org>
Archived-At: <https://www.postgresql.org/message-id/7216E909-5C02-469E-A970-41BEDD4B0242%40msqr.us>
Precedence: bulk


--Apple-Mail=_179C084A-9FA1-4FFD-A1A9-62D141200EAA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On 21 Jan 2026, at 8:52=E2=80=AFPM, Peter Eisentraut =
<peter@eisentraut.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.
>=20
> 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.=

--Apple-Mail=_179C084A-9FA1-4FFD-A1A9-62D141200EAA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;">On 21 Jan =
2026, at 8:52=E2=80=AFPM, Peter Eisentraut &lt;peter@eisentraut.org&gt; =
wrote:<br><div><blockquote type=3D"cite"><span style=3D"font-family: =
Helvetica-Light;">This is just my guess from the outside. &nbsp;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.</span><br><div><br style=3D"caret-color: rgb(0, 0, 0); =
font-family: Helvetica-Light; font-size: 13px; font-style: normal; =
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; =
text-align: start; text-indent: 0px; text-transform: none; white-space: =
normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; =
text-decoration: none;"><span style=3D"caret-color: rgb(0, 0, 0); =
font-family: Helvetica-Light; font-size: 13px; font-style: normal; =
font-variant-caps: normal; font-weight: 400; letter-spacing: normal; =
text-align: start; text-indent: 0px; text-transform: none; white-space: =
normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; =
text-decoration: none; float: none; display: inline !important;">I don't =
know if there is a way to customize this further to get the effect you =
want. &nbsp;Maybe you could reach out to an ICU support forum to get =
more expert insights there.</span></div></blockquote></div><br><div>Ah, =
thank you for your thoughts. I will reach out to the ICU project as you =
suggest.</div></body></html>=

--Apple-Mail=_179C084A-9FA1-4FFD-A1A9-62D141200EAA--