| From: | "Zwettler Markus (OIZ)" <markus(dot)zwettler(at)zuerich(dot)ch> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | ICU database? |
| Date: | 2026-08-05 12:55:19 |
| Message-ID: | GV0P278MB0099D3822E47B2235628D5298BD32@GV0P278MB0099.CHEP278.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm creating a PG cluster with Swiss High German ICU locales.
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2026-08-05 14:12:11 | Re: ICU database? |
| Previous Message | VERDIER Armand | 2026-08-04 09:27:43 | Incompatibility between pg_squeeze and pglogical |