Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8" - Mailing list pgsql-bugs

From Zhongpu Chen
Subject Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
Date
Msg-id CA+1gyqL7uiQhfLcYWpHNUKQgHjQc7sOPthSTiaxLDZzcrGFYSg@mail.gmail.com
Whole thread
Responses Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
List pgsql-bugs
## 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

pgsql-bugs by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: BUG #19362: Extremely log processing of jsonb_path_exists_opr
Next
From: Junwang Zhao
Date:
Subject: Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"