On Wed, 2026-08-05 at 12:55 +0000, Zwettler Markus (OIZ) wrote: > I'm creating a PG cluster with Swiss High German ICU locales. > > I wonder why “collate = C” and “ctype = C” is shown? > > initdb --locale-provider=icu --icu-locale=de-CH-x-icu -D /path/to/datainitdb > > CREATE DATABASE eng001 > WITH > OWNER = dbowner > ENCODING = 'UTF8' > LOCALE_PROVIDER = 'icu' > ICU_LOCALE = 'de-CH-x-icu' > ;
That's because you didn't specify a C library locale, so "initdb" took the setting from your shell environment. Try: initdb --locale-provider=icu --icu-locale=de-CH --locale=de_CH.utf8 -D /path/to/datainitdb Many aspects of the locale are still taken from the C library. It's mostly the collations that will be taken from ICU. Yours, Laurenz Albe
