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: <002d01d97477$f0395640$d0ac02c0$@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>
Comments: In-reply-to "Regina Obe" <lr@pcorp.us>
	message dated "Fri, 21 Apr 2023 13:37:25 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3367225.1682099185.1@sss.pgh.pa.us>
Date: Fri, 21 Apr 2023 13:46:25 -0400
Message-ID: <3367226.1682099185@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3367226.1682099185%40sss.pgh.pa.us>
Precedence: bulk

"Regina Obe" <lr@pcorp.us> writes:
> On my mingw64 setup, I built a test database on PG16 (built with icu
> support) and PG15 (no icu support)

> CREATE DATABASE test TEMPLATE=template0 ENCODING = 'UTF8' LC_COLLATE = 'C'
> LC_CTYPE = 'C';

As has been pointed out already, setting LC_COLLATE/LC_CTYPE is
meaningless when the locale provider is ICU.  You need to look
at what ICU locale is being chosen, or force it with LOCALE = 'C'.

			regards, tom lane