MIME-Version: 1.0
References: <CA+FnnTyJDvLijfizguNahiRO1LMHR4t9=_9-aO8P18cDZ6RRGA@mail.gmail.com>
 <CANzqJaB=zwoYT_rBwUX8q4VyqQBGWyjvAiW=UAJZ0+eh7HU0Zg@mail.gmail.com> <CA+FnnTwpjzm+QNTtyx=J8LGmbS90ceVWaysfzbo-OxNi5Fq2kA@mail.gmail.com>
In-Reply-To: <CA+FnnTwpjzm+QNTtyx=J8LGmbS90ceVWaysfzbo-OxNi5Fq2kA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 3 May 2026 17:05:32 -0400
Message-ID: <CANzqJaABDxgMYHOWVKFgZC-B1-JznyyghCPHVbwUR9datT-MWg@mail.gmail.com>
Subject: Re: Choosing default collation/ctype
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000068b1ea0650f02d74"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaABDxgMYHOWVKFgZC-B1-JznyyghCPHVbwUR9datT-MWg%40mail.gmail.com>
Precedence: bulk

--00000000000068b1ea0650f02d74
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sun, May 3, 2026 at 4:52=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wrot=
e:

> Hi,
>
> On Sun, May 3, 2026 at 3:09=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.c=
om>
> wrote:
> >
> > On Sun, May 3, 2026 at 3:52=E2=80=AFPM 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_conversio=
n
> >> [/code]
> >>
> >> And then I can get a list of collations/ctypes with:
> >>
> >> [code]
> >> SELECT collname, collencoding, collprovider collctype FROM pg_collatio=
n
> >> [/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?"
>
> I don't.
> Just trying to create a generic tool to use for people everywhere...
>

Then choose UTF8.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--00000000000068b1ea0650f02d74
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sun, May 3, 2026 at 4:52=E2=80=AFPM Ig=
or Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</a>&g=
t; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Sun, May 3, 2026 at 3:09=E2=80=AFPM Ron Johnson &lt;<a href=3D"mailto:ro=
nljohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wr=
ote:<br>
&gt;<br>
&gt; On Sun, May 3, 2026 at 3:52=E2=80=AFPM Igor Korot &lt;<a href=3D"mailt=
o:ikorot01@gmail.com" target=3D"_blank">ikorot01@gmail.com</a>&gt; wrote:<b=
r>
&gt;&gt;<br>
&gt;&gt; Hi, ALL,<br>
&gt;&gt; In the CREATE DATABASE statement I can use encoding/collation/ctyp=
e.<br>
&gt;&gt;<br>
&gt;&gt; I can retrieve the encoding list with:<br>
&gt;&gt;<br>
&gt;&gt; [code]<br>
&gt;&gt; SELECT pg_encoding_to_char( conforencoding ) AS name FROM pg_conve=
rsion<br>
&gt;&gt; [/code]<br>
&gt;&gt;<br>
&gt;&gt; And then I can get a list of collations/ctypes with:<br>
&gt;&gt;<br>
&gt;&gt; [code]<br>
&gt;&gt; SELECT collname, collencoding, collprovider collctype FROM pg_coll=
ation<br>
&gt;&gt; [/code]<br>
&gt;&gt;<br>
&gt;&gt; And then add a logic in my UI to switch collations/ctypes based on=
 encoding.<br>
&gt;&gt;<br>
&gt;&gt; However, what I wonder is:<br>
&gt;&gt;<br>
&gt;&gt; Is there a way to select a default collation/ctype for a specific =
encoding?<br>
&gt;&gt;<br>
&gt;&gt; Or maybe I&#39;m overthinking it and I should let the user choose =
and if<br>
&gt;&gt; nothing - just keep those 2 as &quot;Default&quot; and let the ser=
ver pick it<br>
&gt;&gt; up. However it will be weird, especially from me as a user POV.<br=
>
&gt;<br>
&gt;<br>
&gt; You know your data, not us.=C2=A0 The first question I&#39;d try to is=
 &quot;how much client text data is not compatible with bog-standard UTF8?&=
quot;<br>
<br>
I don&#39;t.<br>
Just trying to create a generic tool to use for people everywhere...<br></b=
lockquote><div>=C2=A0</div></div><div>Then choose UTF8.</div><div><br></div=
><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" clas=
s=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butte=
r sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redac=
ted&gt; lobster!</div></div></div></div></div></div>

--00000000000068b1ea0650f02d74--