public inbox for [email protected]
help / color / mirror / Atom feedCharacter with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
2+ messages / 2 participants
[nested] [flat]
* Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
@ 2026-05-01 13:59 Zhongpu Chen <[email protected]>
2026-05-01 15:07 ` Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8" Junwang Zhao <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Zhongpu Chen @ 2026-05-01 13:59 UTC (permalink / raw)
To: [email protected]
## 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
2026-05-01 13:59 Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8" Zhongpu Chen <[email protected]>
@ 2026-05-01 15:07 ` Junwang Zhao <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Junwang Zhao @ 2026-05-01 15:07 UTC (permalink / raw)
To: Zhongpu Chen <[email protected]>; +Cc: [email protected]
On Fri, May 1, 2026 at 9:59 PM Zhongpu Chen <[email protected]> wrote:
>
> ## 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"
Can you try the following statement before select?
SET client_encoding TO 'EUC_CN';
> ```
>
> --
> Zhongpu Chen
--
Regards
Junwang Zhao
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-05-01 15:07 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-05-01 13:59 Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8" Zhongpu Chen <[email protected]>
2026-05-01 15:07 ` Junwang Zhao <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox