public inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Choosing default collation/ctype
Date: Sun, 3 May 2026 16:09:14 -0400
Message-ID: <CANzqJaB=zwoYT_rBwUX8q4VyqQBGWyjvAiW=UAJZ0+eh7HU0Zg@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>
References: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>
On Sun, May 3, 2026 at 3:52 PM Igor Korot <ikorot01@gmail.com> wrote:
> Hi, ALL,
> In the CREATE DATABASE statement I can use encoding/collation/ctype.
>
> I can retrieve the encoding list with:
>
> [code]
> SELECT pg_encoding_to_char( conforencoding ) AS name FROM pg_conversion
> [/code]
>
> And then I can get a list of collations/ctypes with:
>
> [code]
> SELECT collname, collencoding, collprovider collctype FROM pg_collation
> [/code]
>
> And then add a logic in my UI to switch collations/ctypes based on
> encoding.
>
> However, what I wonder is:
>
> 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.
>
You know your data, not us. The first question I'd try to is "how much
client text data is not compatible with bog-standard UTF8?"
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
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: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Choosing default collation/ctype
In-Reply-To: <CANzqJaB=zwoYT_rBwUX8q4VyqQBGWyjvAiW=UAJZ0+eh7HU0Zg@mail.gmail.com>
* 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