Re: Choosing default collation/ctype - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Choosing default collation/ctype
Date
Msg-id ccbb58ad-7136-49ae-a11f-07b2a5b6d0a7@eisentraut.org
Whole thread
In response to Choosing default collation/ctype  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
On 03.05.26 21:52, Igor Korot wrote:
> Is there a way to select a default collation/ctype for a specific encoding?
> 
> Or maybe I'm overthinking it and I should let the user choose and if
> nothing - just keep those 2 as "Default" and let the server pick it
> up. However it will be weird, especially from me as a user POV.

There is no default collation/ctype (locale) for an encoding, only the 
other way around.  So if a user picks as locale, let's say, de_DE@euro, 
then the encoding is automatically LATIN9 (obsolete), if the locale is 
de_DE.utf8, then the encoding is UTF8, and so on.




pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Choosing default collation/ctype