Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: ICU, locale and collation question
Date
Msg-id fbd7f9ec7368c95318e4083256ec0c6196b9ed2f.camel@cybertec.at
Whole thread Raw
In response to Re: ICU, locale and collation question  (Oscar Carlberg <oscar.carlberg@fortnox.se>)
List pgsql-general
Tree view 
On Tue, 2023-05-09 at 08:54 +0200, Oscar Carlberg wrote:
> 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?

That depends on whether you want Swedish or binary sort order
(is "a" < "Z" or not?).  The C collation is not good for natural
language sorting, but it is fast and not subject to collation changes.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: Return rows in input array's order?
Next
From: Peter Eisentraut
Date:
Subject: Re: ICU, locale and collation question