Re: AW: [Extern] Re: ICU database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zwettler Markus (OIZ)" <markus(dot)zwettler(at)zuerich(dot)ch>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: AW: [Extern] Re: ICU database?
Date: 2026-08-05 14:56:46
Message-ID: 1337861.1785941806@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Zwettler Markus (OIZ)" <markus(dot)zwettler(at)zuerich(dot)ch> writes:
> 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

I believe those columns reflect the libc locale settings that are
being used. They don't affect behavior that is driven by ICU ...
but not everything is. You would likely want to set LANG=de_DE
or the like during initdb, along with specifying the ICU locale.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zwettler Markus (OIZ) 2026-08-05 15:01:58 AW: AW: [Extern] Re: ICU database?
Previous Message Zwettler Markus (OIZ) 2026-08-05 14:48:45 AW: [Extern] Re: ICU database?