Hello ? All?
   I on SunOS(Solaris5.8) , PostgreSQL(Version : 7.4) set up a Master -> a Slave SlonyI replicate System
SQL operate : Insert or update
for English handle is correct.
But for chinese (EUC_CN) replicate failed!

createdb -E EUC_CN test
createlang -d test plpgsql

at replicate set have table : (like)
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.

This Question is or not resolve ? wait for you write back,in urgency! Please help me! Thanks very much !

 

__________________________________________________
???????????????
http://cn.mail.yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050722/c99c789c/attachment.html