| Sun.betty 2005-07-22, 3:27 am |
|
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
|