Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group