public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Peter Eisentraut <peter@eisentraut.org>
To: Igor Korot <ikorot01@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Choosing default collation/ctype
Date: Wed, 6 May 2026 08:05:15 +0200
Message-ID: <ccbb58ad-7136-49ae-a11f-07b2a5b6d0a7@eisentraut.org> (raw)
In-Reply-To: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>
References: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>

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.

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 using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: peter@eisentraut.org, ikorot01@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Choosing default collation/ctype
  In-Reply-To: <ccbb58ad-7136-49ae-a11f-07b2a5b6d0a7@eisentraut.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox