My LANG setting already is "LANG=de_CH.utf-8" while I do:
initdb --locale-provider=icu --icu-locale=de-CH-x-icu -D /path/to/
> -----Ursprüngliche Nachricht-----
> Von: Tom Lane <tgl@sss.pgh.pa.us>
> Gesendet: Mittwoch, 5. August 2026 16:57
> An: Zwettler Markus (OIZ) <markus.zwettler@zuerich.ch>
> Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-
> general@lists.postgresql.org
> Betreff: Re: AW: [Extern] Re: ICU database?
>
> "Zwettler Markus (OIZ)" <markus.zwettler@zuerich.ch> writes:
> > Name | Owner | Encoding | Locale Provider | Collate | Ctype |
> > Locale | ICU Rules | Access privileges
> >
> > -----------+----------+----------+-----------------+---------+-------
> > +-------------+-----------+-----------------------
> >
> > eng001 | dbowner | UTF8 | icu | C | C |
> > de-CH-x-icu | | =CTc/dbowner +
> >
> > | | | | | |
> > | | dbowner=CTc/dbowner
>
> I believe those columns reflect the libc locale settings that are being used. They
> don't affect behavior that is driven by ICU ...
> but not everything is. You would likely want to set LANG=de_DE or the like during
> initdb, along with specifying the ICU locale.
>
> regards, tom lane
