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 no data found !

Test 2:
    master db encoding is UNICODE
    slave  db encoding is UNICODE
    PGCLIENTENCODING=UNICODE

    handle English and chinese is correct ! no problem

Test 3:
    master db encoding is EUC_CN
    slave  db encoding is EUC_CN
    PGCLIENTENCODING=UNICODE

    after (export PGCLIENTENCODING=UNICODE ) 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 your help very much !

		
---------------------------------
DO YOU YAHOO!?
  ????G???No.1??????????  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050725/9b8c7a7e/attachment.html