Re: Encoding Problem?

> pgsql 7.2, Linux 2.0.35.
>
> procedure to reproduce incorrect result:
>
> (1)
> either
> initdb -E EUC_TW
> or
> initdb -E MULE_INTERNAL
>
> (2)createdb database1
> (3) psql database1
> (4) create table test (f1 charchar(255) primary key);
> (5) insert into test values('¦¨¥\');
> (6) insert into test values('³\');
>
> 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