pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feeddefault 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>
2023-01-12 15:38 ` Re: default icu locale for new databases (PG15) Laurenz Albe <laurenz.albe@cybertec.at>
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 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>
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