Sun.betty alanxzq
Wed Jul 27 06:42:08 PDT 2005
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050727/f12fea21/attachment.html


More information about the Slony1-general mailing list