Re: ICU database?

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