Sqlyog 5.1 Rc1

[peterlaursen]

/* prepare data */

Code:

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');

/* run this data sync */

Code:

localhost
root ******* 3306 latin1
dba

localhost
root ******* 3306 utf8
dbb

/* and you get */

Code:

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)

Table at target is empty after sync. This cannot be the idea ?!

(only checked Direct Connection)

[Ritesh]

I will check upon this now.

[peterlaursen]

No change with RC2!

[Author]

Posts