Message-ID: <f292cf26e515b425ff35b5ad3eab0d6a8e4d385c.camel@cybertec.at>
Subject: Re: LOCALE C.UTF-8 on EDB Windows v17 server
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dominique Devienne <ddevienne@gmail.com>, pgsql-general@postgresql.org
Date: Wed, 04 Jun 2025 20:01:34 -0500
In-Reply-To: <CAFCRh--rtqbOBpJYFDmPD9kYCYxsxKpLW7LHxYMYhHXa2XoStw@mail.gmail.com>
References: 
	<CAFCRh--rtqbOBpJYFDmPD9kYCYxsxKpLW7LHxYMYhHXa2XoStw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/f292cf26e515b425ff35b5ad3eab0d6a8e4d385c.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-06-04 at 14:23 +0200, Dominique Devienne wrote:
> The command I'm using (from a libpq trace) is:
>=20
> create database "dd_v168" encoding 'UTF8' locale 'C.UTF-8'
> locale_provider 'builtin' template template0
>=20
> On Windows, I'm getting
>=20
> 2025-06-04 14:07:41.227419 B 155 ErrorResponse S "ERROR" V "ERROR" C
> "42809" M "invalid LC_COLLATE locale name: "C.UTF-8"" H "If the locale
> name is specific to ICU, use ICU_LOCALE." F "dbcommands.c" L "1057" R
> "createdb" \x00

Pilot error.  If you use "LOCALE_PROVIDER builtin", you have to specify
BUILTIN LOCALE too:

CREATE DATABASE b
   TEMPLATE template0
   LOCALE_PROVIDER builtin
   BUILTIN_LOCALE 'C.UTF-8'
   /* used for aspects other than collation and character type */
   LOCALE 'C';

Yours,
Laurenz Albe