pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
default icu locale for new databases (PG15)
2+ messages / 2 participants
[nested] [flat]

* default icu locale for new databases (PG15)
@ 2023-01-12 14:56  Robert Sjöblom <robert.sjoblom@fortnox.se>
  0 siblings, 1 reply; 2+ messages in thread

From: Robert Sjöblom @ 2023-01-12 14:56 UTC (permalink / raw)
  To: pgsql-general <pgsql-general@lists.postgresql.org>

Greetings,

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"?

Best regards,
Robert Sjöblom

-- 
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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: default icu locale for new databases (PG15)
@ 2023-01-12 15:38  Laurenz Albe <laurenz.albe@cybertec.at>
  parent: Robert Sjöblom <robert.sjoblom@fortnox.se>
  0 siblings, 0 replies; 2+ messages in thread

From: Laurenz Albe @ 2023-01-12 15:38 UTC (permalink / raw)
  To: Robert Sjöblom <robert.sjoblom@fortnox.se>; pgsql-general <pgsql-general@lists.postgresql.org>

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-01-12 15:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-12 14:56 default icu locale for new databases (PG15) Robert Sjöblom <robert.sjoblom@fortnox.se>
2023-01-12 15:38 ` Laurenz Albe <laurenz.albe@cybertec.at>

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