Re: Order changes in PG16 since ICU introduction - Mailing list pgsql-hackers

"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