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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050725/52c7423b/attachment.html