AW: [Extern] Re: ICU database?

PG18

Debian Trixie

de_CH.utf-8

> -----Ursprüngliche Nachricht-----
> Von: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Gesendet: Mittwoch, 5. August 2026 16:12
> An: Zwettler Markus (OIZ) <markus(dot)zwettler(at)zuerich(dot)ch>; pgsql-
> general(at)lists(dot)postgresql(dot)org
> 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
> adrian(dot)klaver(at)aklaver(dot)com