From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Robert Sjöblom <robert.sjoblom@fortnox.se>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: default icu locale for new databases (PG15)
Date: Thu, 12 Jan 2023 16:38:35 +0100
Message-ID: <665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at> (raw)
In-Reply-To: <90631fa8-242d-806a-da9a-e53d6f5a93f7@fortnox.se>
References: <90631fa8-242d-806a-da9a-e53d6f5a93f7@fortnox.se>
On Thu, 2023-01-12 at 15:56 +0100, Robert Sjöblom wrote:
> When initializing a new database server with a default collation, there
> are a number of different locales available. What's the difference between
>
> 1. se-x-icu
> 2. se-SE-x-icu
> 3. sv-SE-x-icu
>
> ? And, perhaps more importantly, how do I future-proof this so that I'm
> not making a decision today that will make my life worse when upgrading
> from postgres 15 to 16+? For a database with Swedish collation, which
> option is "the best"? Or perhaps "the most foolproof"?
Of the alternatives you list, only "sv-SE-x-icu" makes sense, because "se"
stands for the Sámi or Lapp language, not Swedish.
You could choose between "sv-SE", "sv-FI" and "sv-AX", depending on whether
you are located in Sweden, Finland or the Åland Islands. I don't speak Swedish,
so I don't know how different they are and how they differ from the generic "sv".
I don't think any of these Locales will go away in the forseeable future.
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: laurenz.albe@cybertec.at, robert.sjoblom@fortnox.se
Subject: Re: default icu locale for new databases (PG15)
In-Reply-To: <665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at>
References: <90631fa8-242d-806a-da9a-e53d6f5a93f7@fortnox.se> <665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox