Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppvQI-0004xg-Ok for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:23:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppvQH-0006pX-JB for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Apr 2023 18:23:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppvQH-0006pO-9Y for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:23:53 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ppvQE-0017pR-Qu for pgsql-hackers@lists.postgresql.org; Fri, 21 Apr 2023 18:23:52 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 33LINj253372736; Fri, 21 Apr 2023 14:23:45 -0400 From: Tom Lane To: "Regina Obe" cc: "'Peter Eisentraut'" , "'Sandro Santilli'" , pgsql-hackers@lists.postgresql.org, "'Jeff Davis'" Subject: Re: Order changes in PG16 since ICU introduction In-reply-to: <000001d9747d$066b7560$13426020$@pcorp.us> References: <000b01d97465$c34bbd60$49e33820$@pcorp.us> <3353947.1682092131@sss.pgh.pa.us> <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> <3368986.1682099982@sss.pgh.pa.us> <000001d9747d$066b7560$13426020$@pcorp.us> Comments: In-reply-to "Regina Obe" message dated "Fri, 21 Apr 2023 14:13:49 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3372734.1682101425.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Fri, 21 Apr 2023 14:23:45 -0400 Message-ID: <3372735.1682101425@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Regina Obe" writes: > CREATE DATABASE test1 TEMPLATE=3Dtemplate0 ENCODING =3D 'UTF8' LOCALE =3D= 'C'; > Doesn't seem to work at least not under mingw64 anyway. Hmm, doesn't work for me either: $ LANG=3Den_US.utf8 initdb The files belonging to this database system will be owned by user "postgre= s". This user must also own the server process. Using default ICU locale "en_US". Using language tag "en-US" for ICU locale "en_US". The database cluster will be initialized with this locale configuration: provider: icu ICU locale: en-US LC_COLLATE: en_US.utf8 LC_CTYPE: en_US.utf8 LC_MESSAGES: en_US.utf8 LC_MONETARY: en_US.utf8 LC_NUMERIC: en_US.utf8 LC_TIME: en_US.utf8 ... $ psql postgres psql (16devel) Type "help" for help. postgres=3D# SELECT '+' < '-' ; ?column? = ---------- f (1 row) (as expected, so far) postgres=3D# CREATE DATABASE test1 TEMPLATE=3Dtemplate0 ENCODING =3D 'UTF8= ' LOCALE =3D 'C'; CREATE DATABASE postgres=3D# \c test1 You are now connected to database "test1" as user "postgres". test1=3D# SELECT '+' < '-' ; ?column? = ---------- f (1 row) (wrong!) test1=3D# \l List of databases Name | Owner | Encoding | Locale Provider | Collate | Ctype = | ICU Locale | ICU Rules | Access privileges = -----------+----------+----------+-----------------+------------+---------= ---+------------+-----------+----------------------- postgres | postgres | UTF8 | icu | en_US.utf8 | en_US.ut= f8 | en-US | | = template0 | postgres | UTF8 | icu | en_US.utf8 | en_US.ut= f8 | en-US | | =3Dc/postgres + | | | | | = | | | postgres=3DCTc/postgres template1 | postgres | UTF8 | icu | en_US.utf8 | en_US.ut= f8 | en-US | | =3Dc/postgres + | | | | | = | | | postgres=3DCTc/postgres test1 | postgres | UTF8 | icu | C | C = | en-US | | = (4 rows) Looks like the "pick en-US even when told not to" problem exists here too. regards, tom lane