| Sun.betty 2005-07-25, 3:37 am |
|
I find a interesting phenomena :
Test 1 :
master db encoding is EUC_CN
slave db encoding is EUC_CN
PGCLIENTENCODING=EUC
_CN
chinese sync failed! at master into chinese field value , at slave nodata found !
Test 2:
master db encoding is UNICODE
slave db encoding is UNICODE
PGCLIENTENCODING=UNI
CODE
handle English and chinese is correct ! no problem
Test 3:
master db encoding is EUC_CN
slave db encoding is EUC_CN
PGCLIENTENCODING=UNI
CODE
after (export PGCLIENTENCODING=UNI
CODE ) start slon process.
handle English is correct!
handle chinese have question!
if insert two chinese in field , sync is correct!
if insert three chinese in field , sync is three chinese insert into master db , at slave db field value is two field.
if insert four chinese in field , sync is four chinese insert into master db , at slave db field value is three field.
and so on...
in a word , when length of chinese value filed gt three , so the slave will cut the last chinese.
watch primary key value carefully!
eg:
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)
);
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() , 'ÄÉÄÉÄÉ');
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() , 'ÄÉÄÉÄÉ');
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() , 'ÄÉÄÉÄÉ');
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() , 'ÄÉÄÉÄÉ');
in addition :
look at slon's run log have a lot of :
2005-07-25 13:38:47 CST DEBUG4 remoteHelperThread_1
_1: send DONE/ERROR line to worker
this is what error ? what to cause it ?
if you know ! Please give me some tip! Thanks very much ! Thanks for yourhelp very much !
---------------------------------
DO YOU YAHOO!?
ÑÅ»¢Ãâ·ÑGÓÊÏä£_No. 1µÄ·À¶¾·ÀÀ¬»ø³¬´óÓÊÏ
ä
|