Re: ICU database?

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