On Wed, 2025-06-04 at 14:23 +0200, Dominique Devienne wrote: > The command I'm using (from a libpq trace) is: > > create database "dd_v168" encoding 'UTF8' locale 'C.UTF-8' > locale_provider 'builtin' template template0 > > On Windows, I'm getting > > 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
