ICU database?

[Zwettler Markus (OIZ)]

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)