public inbox for [email protected]
help / color / mirror / Atom feedRe: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
2+ messages / 2 participants
[nested] [flat]
* Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8"
@ 2026-05-01 16:09 Zhongpu Chen <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Zhongpu Chen @ 2026-05-01 16:09 UTC (permalink / raw)
To: Junwang Zhao <[email protected]>; +Cc: [email protected]
```
demo_euc_cn_db=# SET client_encoding TO 'EUC_CN';
SET
demo_euc_cn_db=# SELECT * FROM t WHERE id = 1;
id | s
----+----
1 | ��
(1 row)
```
Since 0xA2A3 is invalid in EUC-CN, it cannot be mapped to any meaningful
character. Currently, EUC-CN allows all 2-byte within A1-EF, but this
coarse-grained approach is flawed.
On Fri, May 1, 2026 at 11:07 PM Junwang Zhao <[email protected]> wrote:
> 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
>
--
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-02 01:25 Junwang Zhao <[email protected]>
parent: Zhongpu Chen <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Junwang Zhao @ 2026-05-02 01:25 UTC (permalink / raw)
To: Zhongpu Chen <[email protected]>; +Cc: [email protected]
On Sat, May 2, 2026 at 12:09 AM Zhongpu Chen <[email protected]> wrote:
>
>
> ```
> demo_euc_cn_db=# SET client_encoding TO 'EUC_CN';
> SET
> demo_euc_cn_db=# SELECT * FROM t WHERE id = 1;
> id | s
> ----+----
> 1 | ��
> (1 row)
> ```
>
> Since 0xA2A3 is invalid in EUC-CN, it cannot be mapped to any meaningful character. Currently, EUC-CN allows all 2-byte within A1-EF, but this coarse-grained approach is flawed.
This seems more like a feature request than a bug. It would make sense
to close the bug report and start a discussion on the hackers mailing
list instead.
>
> On Fri, May 1, 2026 at 11:07 PM Junwang Zhao <[email protected]> wrote:
>>
>> 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
>
>
>
> --
> Zhongpu Chen
--
Regards
Junwang Zhao
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-05-02 01:25 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-05-01 16:09 Re: Character with byte sequence 0xa2 0xa3 in encoding "EUC_CN" has no equivalent in encoding "UTF8" Zhongpu Chen <[email protected]>
2026-05-02 01:25 ` 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