Altova User Support Forum

Welcome Guest

IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Altova User Forums » Members » zanders

Profile: zanders

About
User Name:	zanders
Forum Rank:	Newbie
Real Name:
Location
Occupation:
Interests:
Gender:	None Specified

Statistics
Joined:	Friday, June 5, 2009
Last Visit:	Friday, June 5, 2009 1:56:57 PM
Number of Posts:	1 [0.01% of all post / 0.00 posts per day]

Avatar

Last 10 Posts
Topic: Data Truncate Posted: Friday, June 5, 2009 1:14:22 PM
I'm using DiffDog Enterprise 2009 doing a database compare btw MySQL 5.0 and SQL Server 2008. I'm using the MySQL ODBC driver 5.1. The schemas are the same and the data should be the same also. All fields are equal except for one. The MySQL data type is text and the SQL Server type is also text. The field has about 17,000 characters in it and when I do a compare of the data that each query tool returns, the data is the same. DiffDog, however, is truncating the MySQL data to around 3800 characters so it thinks that the data is different. Is this a bug with DiffDog or is there some issue with the ODBC driver for MySQL?

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.

user forum