> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org