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]
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