Re: Encoding Problem? - Mailing list pgsql-bugs

From Tatsuo Ishii
Subject Re: Encoding Problem?
Date
Msg-id 20020305100151W.t-ishii@sra.co.jp
Whole thread Raw
In response to Encoding Problem?  (<cnliou@eurosport.com>)
List pgsql-bugs
> pgsql 7.2, Linux 2.0.35.
>=20
> procedure to reproduce incorrect result:
>=20
> (1)
> either
> initdb -E EUC_TW
> or
> initdb -E MULE_INTERNAL
>=20
> (2)createdb database1
> (3) psql database1
> (4) create table test (f1 charchar(255) primary key);
> (5) insert into test values('=A6=A8=A5\');
> (6) insert into test values('=B3\');
>=20
> Explanation:
> step (5) and (6) insert 2 different traditional
> Chinese strings. The first string contains 2
> characters(4 bytes) and the second string contains 1
> character (2 bytes).

I guess you are inserting correct EUC Traditional Chinese (EUC-TW)
characters but hard to tell what is happening unless you are showing
us the character sequences in hexa decimal format.
--
Tatsuo Ishii

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #607: to_date() function bug
Next
From: Justin
Date:
Subject: Re: postmaster problem....