From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Regina Obe" <lr@pcorp.us>
cc: "'Peter Eisentraut'" <peter.eisentraut@enterprisedb.com>,
        "'Sandro Santilli'" <strk@kbt.io>, pgsql-hackers@lists.postgresql.org,
        "'Jeff Davis'" <pgsql@j-davis.com>
Subject: Re: Order changes in PG16 since ICU introduction
In-reply-to: <003b01d9747a$910471c0$b30d5540$@pcorp.us>
References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <ZELDOktA75yYG4Z2@hst.kbt.io> <533d93c5-f604-8e5f-4a48-975c08c53d59@enterprisedb.com> <3365333.1682098091@sss.pgh.pa.us> <002d01d97477$f0395640$d0ac02c0$@pcorp.us> <3367226.1682099185@sss.pgh.pa.us> <003b01d9747a$910471c0$b30d5540$@pcorp.us>
Comments: In-reply-to "Regina Obe" <lr@pcorp.us>
	message dated "Fri, 21 Apr 2023 13:56:14 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3368985.1682099982.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 21 Apr 2023 13:59:42 -0400
Message-ID: <3368986.1682099982@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3368986.1682099982%40sss.pgh.pa.us>
Precedence: bulk

"Regina Obe" <lr@pcorp.us> writes:
> Okay got it was on IRC with RhodiumToad and he suggested:
> CREATE DATABASE test2 TEMPLATE=3Dtemplate0 ENCODING =3D 'UTF8' LC_COLLAT=
E =3D 'C'
> LC_CTYPE =3D 'C' ICU_LOCALE=3D'C';

> Which gives expected result:
> SELECT '+'  <  '-'  ;  -- true

>  but gives me a notice:
> NOTICE:  using standard form "en-US-u-va-posix" for locale "C"

Yeah.  My recommendation is just LOCALE:

regression=3D# CREATE DATABASE test1 TEMPLATE=3Dtemplate0 ENCODING =3D 'UT=
F8' LOCALE =3D 'C';
CREATE DATABASE
regression=3D# CREATE DATABASE test2 TEMPLATE=3Dtemplate0 ENCODING =3D 'UT=
F8' ICU_LOCALE =3D 'C';
NOTICE:  using standard form "en-US-u-va-posix" for locale "C"
CREATE DATABASE

I think it's probably intentional that ICU_LOCALE is stricter
about being given a real ICU locale name, but I didn't write
any of that code.

			regards, tom lane