Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEha3-004JAN-32 for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 05:54:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEha3-000oH4-07 for pgsql-general@arkaria.postgresql.org; Mon, 20 Apr 2026 05:53:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wEha2-000oGv-2G for pgsql-general@lists.postgresql.org; Mon, 20 Apr 2026 05:53:58 +0000 Received: from mail.hjp.at ([212.17.106.138] helo=rorschach.hjp.at) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wEhZz-00000001sQ9-1w4P for pgsql-general@lists.postgresql.org; Mon, 20 Apr 2026 05:53:57 +0000 Received: by rorschach.hjp.at (Postfix, from userid 1000) id 7D6DAAD35; Mon, 20 Apr 2026 07:53:52 +0200 (CEST) Date: Mon, 20 Apr 2026 07:53:52 +0200 From: "Peter J. Holzer" To: pgsql-general@lists.postgresql.org Subject: Re: List of encodings Message-ID: Mail-Followup-To: pgsql-general@lists.postgresql.org References: <71cd4015-9002-4173-bd9a-075f7afb3c20@aklaver.com> <5f263a8a-9c30-4118-b410-6e25eafde156@aklaver.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="arch4q4czhlxaaiu" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --arch4q4czhlxaaiu Content-Type: text/plain; protected-headers=v1; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Subject: Re: List of encodings MIME-Version: 1.0 On 2026-04-19 20:13:29 -0500, Igor Korot wrote: > So, let's say I chose "BIG5"". >=20 > As stated the table contains: >=20 > big5_to_utf8 | BIG5 | t > big5_to_euc_tw | BIG5 | t > big5_to_mic | BIG5 | t >=20 > Since all 3 are default character sets, which one would be chosen? > (in the context of CREATE DATABASE) Note that the table contains *two* encodings (conforencoding and contoencoding) for each conversion. If you look at both it becomes clear: hjp=3D> select conname, pg_encoding_to_char(conforencoding) as for_enc, pg_encoding_to_char(contoencoding) to_enc, condefault from pg_conversion where conname like 'big5%'; =E2=95=94=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2= =95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95= =90=E2=95=A4=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90= =E2=95=90=E2=95=90=E2=95=A4=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2= =95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95= =90=E2=95=90=E2=95=A4=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90= =E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=97 =E2=95=91 conname =E2=94=82 for_enc =E2=94=82 to_enc =E2=94= =82 condefault =E2=95=91 =E2=95=9F=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2= =94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94= =80=E2=94=80=E2=94=BC=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80= =E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=95=A2 =E2=95=91 big5_to_euc_tw =E2=94=82 BIG5 =E2=94=82 EUC_TW =E2=94= =82 t =E2=95=91 =E2=95=91 big5_to_mic =E2=94=82 BIG5 =E2=94=82 MULE_INTERNAL =E2=94= =82 t =E2=95=91 =E2=95=91 big5_to_utf8 =E2=94=82 BIG5 =E2=94=82 UTF8 =E2=94= =82 t =E2=95=91 =E2=95=9A=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2= =95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95= =90=E2=95=A7=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90= =E2=95=90=E2=95=90=E2=95=A7=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2= =95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95= =90=E2=95=90=E2=95=A7=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90= =E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=90=E2=95=9D (3 rows) If you need to convert from BIG5 to UTF8, big5_to_utf8 is the default (and indeed only) conversion. If you need to convert from BIG5 to EUC_TW, it's big5_to_euc_tw, etc. hjp --=20 _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" --arch4q4czhlxaaiu Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmnlv2kACgkQ8g5IURL+ KF072A//cmZ5gzDzvb1bqzG4tlsggkX6MxINMMrxWyXGaLZo9kkfvCoX1XQYWFaW M+cYEb0Up02UduAwWYH8wMRDl5olIrJUBw6/tTUU500w0k4zW56cqssSfugjne1g wzwMgNkrrswllVSm7ZQ7urrIRjxLM6sPnPLEIbrXLHOk7Wdwur1bdd5gdGy8J/R0 05n645KPthn6IqSh2sQLKgny5pB0EOLY3rtREfksdpJSVPC1hj29eplOEFsbO5aW sHzkJ8ulaO3cxc/vztYJaYXZVSzkpbTy954qibEo+QwNJVHdGVrlx+40A5BS9tqG Flo56cbksY6Cb2RBoq0uvb6X/KSuy5P70kePHlULx4b3h7kutudffC4R8lfw3E5y X+DOrMDj+aB217DvY3ARICILOk5eOmbjECkIFsA298aWq0vgB00c/jllPtPGNS2K VCW/DhfVAKx2kXO8Z3y6nHhnPL3JLy4OEKNDm1GZ3NJBOz4GXvYNrC9cHHEof3Wa NuNgbKQd7hjdpSJtkCjOV5sw7GrbAqCHFhXj9Q+s3dxNJJSLQLc6LAthofEuUux7 rgK0IgV+xqHm4NvLpo51GYh9hDzeJTyEIWSZn/r8SlaoHyOXRDctVqxRXkl2w9Qu Gu+sfFR+xyGk/D4sgu93+VSFC09ZluNDxfATvXsOYE3KOSFn70c= =4mPk -----END PGP SIGNATURE----- --arch4q4czhlxaaiu--