AW: AW: [Extern] Re: ICU database?

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(at)sss(dot)pgh(dot)pa(dot)us>
> Gesendet: Mittwoch, 5. August 2026 16:57
> An: Zwettler Markus (OIZ) <markus(dot)zwettler(at)zuerich(dot)ch>
> Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; pgsql-
> general(at)lists(dot)postgresql(dot)org
> Betreff: Re: AW: [Extern] Re: ICU database?
>
> "Zwettler Markus (OIZ)" <markus(dot)zwettler(at)zuerich(dot)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