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 <[email protected]> > Gesendet: Mittwoch, 5. August 2026 16:57 > An: Zwettler Markus (OIZ) <[email protected]> > Cc: Adrian Klaver <[email protected]>; pgsql- > [email protected] > Betreff: Re: AW: [Extern] Re: ICU database? > > "Zwettler Markus (OIZ)" <[email protected]> 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
