MIME-Version: 1.0
From: Zhongpu Chen <chenloveit@gmail.com>
Date: Fri, 1 May 2026 21:59:18 +0800
Message-ID: <CA+1gyqL7uiQhfLcYWpHNUKQgHjQc7sOPthSTiaxLDZzcrGFYSg@mail.gmail.com>
Subject: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no
 equivalent in encoding "UTF8"
To: pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000610d360650c1fd58"
Archived-At: <https://www.postgresql.org/message-id/CA%2B1gyqL7uiQhfLcYWpHNUKQgHjQc7sOPthSTiaxLDZzcrGFYSg%40mail.gmail.com>
Precedence: bulk

--000000000000610d360650c1fd58
Content-Type: text/plain; charset="UTF-8"

## Description

The legacy encodings allow some invalid bytes, which will cause errors
during SELECT operations.

## How to reproduce

```shell
createdb -E EUC_CN -T template0 --locale=C demo_euc_cn_db
```

```sql
demo_euc_cn_db=# CREATE TABLE t(id int, s varchar(10));

demo_euc_cn_db=# INSERT INTO t VALUES(1, E'\xA2\xA3');
INSERT 0 1
demo_euc_cn_db=# SELECT * FROM t WHERE id = 1;
ERROR:  character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no
equivalent in encoding "UTF8"
```

-- 
Zhongpu Chen

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

<div dir=3D"ltr"><div>## Description</div><div><br></div><div>The legacy en=
codings allow some invalid bytes, which will cause errors during SELECT ope=
rations.</div><div><br></div><div>## How to reproduce=C2=A0</div><div><br><=
/div><div>```shell</div><div>createdb -E EUC_CN -T template0 --locale=3DC d=
emo_euc_cn_db</div><div>```</div><div><br></div><div>```sql</div><div>demo_=
euc_cn_db=3D# CREATE TABLE t(id int, s varchar(10));</div><div><br></div><d=
iv>demo_euc_cn_db=3D# INSERT INTO t VALUES(1, E&#39;\xA2\xA3&#39;);<br>INSE=
RT 0 1<br>demo_euc_cn_db=3D# SELECT * FROM t WHERE id =3D 1;<br>ERROR: =C2=
=A0character with byte sequence 0xa2 0xa3 in encoding &quot;EUC_CN&quot; ha=
s no equivalent in encoding &quot;UTF8&quot;</div><div>```</div><div><br></=
div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" c=
lass=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr=
">Zhongpu Chen</div></div></div>

--000000000000610d360650c1fd58--