create database `dba` default charset = latin1;
create database `dbb` default charset = utf8;
create table `dba`.`tbla` (    `id` bigint   NOT NULL AUTO_INCREMENT ,  `t` varchar (50)   NULL  , PRIMARY KEY ( `id` )  );
create table `dbb`.`tbla` (    `id` bigint   NOT NULL AUTO_INCREMENT ,  `t` varchar (50)   NULL  , PRIMARY KEY ( `id` )  );
insert into `dba`.`tbla` (`id`,`t`) values ( NULL,'it is important to write \'æøå\'');
insert into `dbb`.`tbla` (`id`,`t`) values ( NULL,'it is important');

<job version="4.2">
<syncjob>
<abortonerror abort="no" />
<fkcheck check="no" />
<source>
<host>localhost</host>
<user>root</user>
<pwd>*******</pwd>
<port>3306</port>
<charset>latin1</charset>
<database>dba</database>
</source>
<target>
<host>localhost</host>
<user>root</user>
<pwd>*******</pwd>
<port>3306</port>
<charset>utf8</charset>
<database>dbb</database>
</target>
<tables all="yes" />
</syncjob>
</job>

SQLyog Job Agent Version 5.1
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Apr 18 14:47:56 2006


Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`tbla`                           1        1         0        1        1  


Total time taken - 1 sec(s)