Re: Encoding Problem?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: cnliou(at)eurosport(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Encoding Problem?
Date: 2002-03-05 01:01:51
Message-ID: 20020305100151W.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Justin 2002-03-05 02:50:22 Re: postmaster problem....
Previous Message Tom Lane 2002-03-04 21:54:17 Re: Bug #607: to_date() function bug