PG18 Debian Trixie
de_CH.utf-8 > -----Ursprüngliche Nachricht----- > Von: Adrian Klaver <[email protected]> > Gesendet: Mittwoch, 5. August 2026 16:12 > An: Zwettler Markus (OIZ) <[email protected]>; pgsql- > [email protected] > Betreff: [Extern] Re: ICU database? > > --- Externe Email: Vorsicht mit Anhängen, Links oder dem Preisgeben von > Informationen --- > > On 8/5/26 5:55 AM, Zwettler Markus (OIZ) wrote: > > I'm creating a PG cluster with Swiss High German ICU locales. > > What Postgres version? > > What OS and version? > > What is the OS locale? > > > > > > > > > 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' > > > > ; > > > > postgres=# \l > > > > List of databases > > > > 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 > > > > postgres | postgres | UTF8 | icu | C | C | > > de-CH-x-icu | | > > > > template0 | postgres | UTF8 | icu | C | C | > > de-CH-x-icu | | =c/postgres + > > > > | | | | | | > > | | postgres=CTc/postgres > > > > template1 | postgres | UTF8 | icu | C | C | > > de-CH-x-icu | | =c/postgres + > > > > | | | | | | > > | | postgres=CTc/postgres > > > > (4 rows) > > > > > > > > > -- > Adrian Klaver > [email protected]
