ICU database?

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)

Responses

Browse pgsql-general by date

  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