wont compare some columns

va2dos

Hi there, I have some column when i compare with MySqlCompare they show has identical, but when i try to sync the data, it refuse to compare some varchar field marked with a yellow (!) sign w/o any other indications

here's the Table creations script and a screen shot of mySqlCompare

CREATE TABLE `rabbids_sb`.`share_definition_message` (
`id` int(10) NOT NULL auto_increment,
`share_definition_id` int(10) NOT NULL DEFAULT 0,
`title` varchar(100) NOT NULL DEFAULT '0',
`description` varchar(100) NOT NULL DEFAULT '0',
`image` varchar(100) NOT NULL DEFAULT 'shareimage_test.png',
`link` varchar(100) NOT NULL DEFAULT 'StartPlaying_Link1',
PRIMARY KEY (`id`),
CONSTRAINT `fk_share_definition_message_def_id` FOREIGN KEY (`share_definition_id`) REFERENCES `rabbids_sb`.`share_definition` (`id`),
KEY `fk_share_definition_message_def_id`(`share_definition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

[/img]

neil.anderson

Hi va2dos,

I've contacted you via email to get some more info.

Thanks,
Neil