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]
