Hi!
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('=A6=A8=A5\');
(6) insert into test values('=B3\');
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).
When the inserts are conducted through postgresqlODBC
7.01.0009, no error message occures but incorrect
strings are saved(and changed) in the backend.
When the inserts are done by psql command prompts, we
can see psql mis-interprets the strings as:
database1=3D# insert into test values('=A6=A8=A5\');
database1'#
The result is that, the 2-character Chinese string
probably contains the ASCII character ' which
confuses postgresql. The second insert confuses
postgresql the same way (because the character
contains ' ascii code?).
Regards,
CN
--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com