Red Gate forums :: View topic - wont compare some columns
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Data Compare
MySQL Data Compare forum

wont compare some columns

Search in MySQL Data Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
va2dos



Joined: 15 Nov 2011
Posts: 1

PostPosted: Tue Nov 15, 2011 3:23 pm    Post subject: wont compare some columns Reply with quote

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]https://picasaweb.google.com/lh/photo/R9OHuBdS_qBBZVFStQo-hBXrGPMzQh26VmK1pyGcI6Q?feat=directlink[/img][/img]
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Tue Nov 15, 2011 4:32 pm    Post subject: Reply with quote

Hi va2dos,

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

Thanks,
Neil
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group