pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (2+ messages)

Message-ID: <665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at>
Permalink:  ../665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at/
Also on:    postgresql.org/message-id/665febd71c7fc4237020a96eb2f59fe548a28385.camel@cybertec.at

 · 

reply

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