Home > Archive > Slony1 PostgreSQL Replication > July 2005 > about slonyI handle chinese question









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author about slonyI handle chinese question
Sun.betty

2005-07-27, 3:26 am

Hello!
All!
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('东' , 1 , now() , '6东东东东东东');

I find :
when db encoding is UNICODE :
at master : data was insert correct
type | currval | currdate | memo
------+---------+------------+---------------
东 | 1 | 2005-07-27 | 6东东东东东东
at slave :
type | currval | currdate | memo
------+---------+------------+-------------
东 | 1 | 2005-07-27 | 6东东东东东

look at the last field value . was subtract one chinese letter.

at db encoding = EUC_CN :
at master : insert correct
type | currval | currdate | memo
------+---------+------------+---------------
东 | 1 | 2005-07-27 | 6东东东东东东

at slave :
type | currval | currdate | memo
------+---------+------------+-----------
东 | 1 | 2005-07-27 | 6东东东东

look at the last field value , was subtract two chinese letter.

I think maybe is slonyI's trigger handle chinese have coding question.

look forward to resolve this question. this very important for slonyI perfect.
Thanks for your help very much !

____________________
____________________
__________
赶快注册雅虎超大容量
免费邮箱?
http://cn.mail.yahoo.com
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com