Rank: Newbie
Joined: 6/5/2009
Posts: 1
|
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?
|
Rank: Advanced Member
Joined: 9/9/2005
Posts: 483
Location: AT
|
Hello,
This appears to be a bug we are aware of with 'text' columns using a 'utf8_unicode_ci' collation" in MySQL. Apologies for the inconvenience - we'll get it fixed as soon as possible...
|
