| Sun.betty 2005-07-25, 3:37 am |
|
Hello!
All "prawn" for SlonyI of Steady improvement.
at first! Thanks very much for help all along. I have a very importance question!
Haven't anybody befell about chinese handled question?
and I test find when the encoding is "UNICODE" ! the sync of english and chinese no problem!
but for encoding is "EUC_CN" the sync of english is correct !but for chinese is sync not happen!
if you know !Please help me! now my product system use slonyI do sync. encoding not allow to change.
really no way to resolve?
createdb -E EUC_CN test
createlang -d test plpgsql
at replicate set have table :
create table T_NUM_CENTER (
TYPE VARCHAR( 8 ) not null,
CURRVAL INT4 not null default 1,
CURRDATE DATE not null default 'NOW()',
MEMO VARCHAR(64) null,
constraint PK_T_NUM_CENTER_TYPE
primary key (TYPE)
);
at Master :
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('a' ,1 , now() , 'a');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('b' ,1 , now() , 'b');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('c' ,1 , now() , 'c');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('d' ,1 , now() , 'd');
select * from T_NUM_CENTER where TYPE in ('a','b','c','d');
Master and slave replicate is correct.
But ....
at Master : use chinese
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('东东东' , 1 , now() , '东东东');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('嘻嘻嘻' , 1 , now() , '嘻嘻嘻');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('贝贝北' , 1 , now() , '贝贝北');
insert into T_NUM_CENTER (TYPE , CURRVAL , CURRDATE , MEMO) values ('纳纳纳' , 1 , now() , '纳纳纳');
select * from T_NUM_CENTER where TYPE in ('东东东','嘻嘻嘻','
贝贝北','纳纳纳');
At Master : Data was inserted table ;
But at slave . no data found . replicate failed!
SQL operate : Update as the same.
Please help me! Thanks for your help first!
____________________
____________________
__________
赶快注册雅虎超大容量
免费邮箱?
http://cn.mail.yahoo.com
|