Re: ICU, locale and collation question - Mailing list pgsql-general

From Oscar Carlberg
Subject Re: ICU, locale and collation question
Date
Msg-id 4210aaef-06ff-628e-a2c8-a1a4bf28d278@fortnox.se
Whole thread Raw
In response to Re: ICU, locale and collation question  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: ICU, locale and collation question
Re: ICU, locale and collation question
List pgsql-general
On 5/8/23 22:07, Laurenz Albe wrote:

> Yes, that is safe.
>
> But it is not compatible with the old setup when it comes to lc_time,
> lc_messages and the others.  You should use sv_SE.UTF-8 for these
> locale categories.
>
> Note that that won't cause problems with upgrading the C library.
>
> Yours,
> Laurenz Albe
>
Thank you very much for clarifying!

Our initdb setup would then look like this for compatibility;
-E 'UTF-8'
--locale-provider=icu
--icu-locale=sv-SE-x-icu
--lc_monetary=sv_SE.UTF-8
--lc-numeric=sv_SE.UTF-8
--lc-time=sv_SE.UTF-8
--lc-messages=en_US.UTF-8

Should we still provide createdb with --lc-collate=C and --lc-ctype=C,
or should we set those to sv_SE.UTF-8 as well?

Best regards,
Oscar


--
Innehållet i detta e-postmeddelande är konfidentiellt och avsett endast för
adressaten.Varje spridning, kopiering eller utnyttjande av innehållet är
förbjuden utan tillåtelse av avsändaren. Om detta meddelande av misstag
gått till fel adressat vänligen radera det ursprungliga meddelandet och
underrätta avsändaren via e-post



pgsql-general by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: "PANIC: could not open critical system index 2662" - twice
Next
From: Evgeny Morozov
Date:
Subject: Re: "PANIC: could not open critical system index 2662" - twice