MIME-Version: 1.0
In-Reply-To: <CA+FnnTzuO6qXVt-_UN_y5odFEZPD8a6sZh37TELmaoqKnvxTVQ@mail.gmail.com>
References: <CA+FnnTxFMiA+KMfypfGyY43G2kSx6-t5A351snUMmWC-2Lxvaw@mail.gmail.com>
 <CAKFQuwZOH6BPtaWJKr9jRGxdJt05YtLAZn1s_fYt=uzAASm9CQ@mail.gmail.com>
 <CA+FnnTymNs9_3pBci01_Uu5OTNJFngOhu8_khpmUs88V8kX86Q@mail.gmail.com>
 <71cd4015-9002-4173-bd9a-075f7afb3c20@aklaver.com> <CA+FnnTzx90AzTu07zVGMCYmvBYs_VsL9k2E7eBkzg_rTRwZbeA@mail.gmail.com>
 <5f263a8a-9c30-4118-b410-6e25eafde156@aklaver.com> <CA+FnnTxJyrnxR0hhV8T8J7Gb=MZ=OrtrEUcyoMf14-WHKgSb-A@mail.gmail.com>
 <CANzqJaBRRq5T-3VJc5fzGSOotAW8eXg1cvh0XwoRc4akO+mamg@mail.gmail.com>
 <CA+FnnTy2D85znPLd-G47Uyt4RTF289g45XnSXrLQEHG8CeN2qg@mail.gmail.com>
 <CA+FnnTx_RXR_3CY6TbO8ov+Ky+VoiDEopmBisPMA9+cWoZqAMw@mail.gmail.com>
 <CAKFQuwacHL53WNxg_wcL1Zqs=pVMZPtq4yufUBLTSNJ+aAX-JA@mail.gmail.com> <CA+FnnTzuO6qXVt-_UN_y5odFEZPD8a6sZh37TELmaoqKnvxTVQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 20 Apr 2026 21:32:06 -0700
Message-ID: <CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ@mail.gmail.com>
Subject: Re: List of encodings
To: Igor Korot <ikorot01@gmail.com>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000dade7a064ff0e5c9"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZcTd9ixAZa1Uei5k8gwUrnCqZsb6JrGccxMGMCGNURMQ%40mail.gmail.com>
Precedence: bulk

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

On Monday, April 20, 2026, Igor Korot <ikorot01@gmail.com> wrote:

> Hi, everybody,
>
> On Mon, Apr 20, 2026 at 8:29=E2=80=AFPM David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> >
> > On Mon, Apr 20, 2026 at 7:47=E2=80=AFPM Igor Korot <ikorot01@gmail.com>=
 wrote:
> >>
> >> My understanding is that if I have 3 "BIG5" encodings, only one can be
> >> a default.
> >
> >
> > That would be a misunderstanding of what a conversion table is about.
>
> What I did:
>
> 1. Google "PostgreSQL create database"
> 2. Click the first link - to PostgreSQL documentation.
> 3. The command have many options. One of them is "Encoding".
> 4, Scrolled down for an explanation. The explanation had a link.
> 5. Clicked the link. Received a page with the list of encodings.
>
> At this point I asked the original question
> Does the list on that page stored somewhere? Or it is hardcoded inside
> the sources?
>
> That's when I started receiving a references to that table.
>
> Did I ask the wrong question?
>

And the answer you got was =E2=80=9Cno, it=E2=80=99s not (i.e., it=E2=80=99=
s hardcoded inside), but
you can get to it indirectly=E2=80=9D.  In this case if you involve the
pgconversion table you should ignore the conversion is default field as it
has nothing to do with the question - what encodings does the system
recognize.  You also got an answer involving generate_series.

David J.

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

On Monday, April 20, 2026, Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.=
com">ikorot01@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi=
, everybody,<br>
<br>
On Mon, Apr 20, 2026 at 8:29=E2=80=AFPM David G. Johnston<br>
&lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.co=
m</a>&gt; wrote:<br>
&gt;<br>
&gt; On Mon, Apr 20, 2026 at 7:47=E2=80=AFPM Igor Korot &lt;<a href=3D"mail=
to:ikorot01@gmail.com">ikorot01@gmail.com</a>&gt; wrote:<br>
&gt;&gt;<br>
&gt;&gt; My understanding is that if I have 3 &quot;BIG5&quot; encodings, o=
nly one can be<br>
&gt;&gt; a default.<br>
&gt;<br>
&gt;<br>
&gt; That would be a misunderstanding of what a conversion table is about.<=
br>
<br>
What I did:<br>
<br>
1. Google &quot;PostgreSQL create database&quot;<br>
2. Click the first link - to PostgreSQL documentation.<br>
3. The command have many options. One of them is &quot;Encoding&quot;.<br>
4, Scrolled down for an explanation. The explanation had a link.<br>
5. Clicked the link. Received a page with the list of encodings.<br>
<br>
At this point I asked the original question<br>
Does the list on that page stored somewhere? Or it is hardcoded inside<br>
the sources?<br>
<br>
That&#39;s when I started receiving a references to that table.<br>
<br>
Did I ask the wrong question?<br>
</blockquote><div><br></div><div>And the answer you got was =E2=80=9Cno, it=
=E2=80=99s not (i.e., it=E2=80=99s hardcoded inside), but you can get to it=
 indirectly=E2=80=9D.=C2=A0 In this case if you involve the pgconversion ta=
ble you should ignore the conversion is default field as it has nothing to =
do with the question - what encodings does the system recognize.=C2=A0 You =
also got an answer involving generate_series.</div><div><br></div><div>Davi=
d J.</div><div>=C2=A0=C2=A0</div>

--000000000000dade7a064ff0e5c9--