MIME-Version: 1.0
References: <CAFCRh--rtqbOBpJYFDmPD9kYCYxsxKpLW7LHxYMYhHXa2XoStw@mail.gmail.com>
 <2cd2cf04ba6ea21678b893dbfebe97bcf82726dc.camel@j-davis.com> <CAFCRh-8jd+VSPW5LXLYvmu8ByRhcqBB_dQoG1UsTHrcS8UJXFA@mail.gmail.com>
In-Reply-To: <CAFCRh-8jd+VSPW5LXLYvmu8ByRhcqBB_dQoG1UsTHrcS8UJXFA@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Thu, 5 Jun 2025 11:34:48 +0200
Message-ID: <CAFCRh--zj2brnZwGPc3LL59EORgMT0pHRt82HfH6jPRszumpvg@mail.gmail.com>
Subject: Re: LOCALE C.UTF-8 on EDB Windows v17 server
To: Jeff Davis <pgsql@j-davis.com>
Cc: pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh--zj2brnZwGPc3LL59EORgMT0pHRt82HfH6jPRszumpvg%40mail.gmail.com>
Precedence: bulk

On Thu, Jun 5, 2025 at 11:07=E2=80=AFAM Dominique Devienne <ddevienne@gmail=
.com> wrote:
> So... It is possible to have the SAME command on Windows and Linux,
> which yields the SAME datcollate and datctype values???
> So far, such a command eludes me, I'm afraid. --DD

So I tried to be explicit about lc_collate and lc_ctype too.
OK on Linux, KO on Windows...

Windows:
ddevienne=3D> create database "dd_v168b" encoding 'UTF8' builtin_locale
'C.UTF-8' lc_collate 'C.UTF-8' lc_ctype 'C.UTF-8'
ddevienne-> locale_provider 'builtin' template template0;
ERROR:  invalid LC_COLLATE locale name: "C.UTF-8"
HINT:  If the locale name is specific to ICU, use ICU_LOCALE.

Linux:
ddevienne=3D> create database "dd_v168c" encoding 'UTF8' builtin_locale
'C.UTF-8' lc_collate 'C.UTF-8' lc_ctype 'C.UTF-8'
ddevienne-> locale_provider 'builtin' template template0;
CREATE DATABASE
ddevienne=3D> select datlocprovider, datlocale, datcollate, datctype
from pg_database where datname =3D 'dd_v168c';
 datlocprovider | datlocale | datcollate | datctype
----------------+-----------+------------+----------
 b              | C.UTF-8   | C.UTF-8    | C.UTF-8
(1 row)

AFAIK, C and C.UTF-8 are NOT the same thing, for collations.
It is indeed super confusing Jeff. I'm lost.

How can I get a

datlocprovider | datlocale | datcollate | datctype
----------------+-----------+------------+----------
 b              | C.UTF-8   | C.UTF-8    | C.UTF-8

database on Windows *AND* Linux?
If not possible using the same SQL (but why...), using what SQL?