Char(n) columns not comparing correctly in 18.104.22.168
When I compare table A in database A to the exact same table (structure and data) table A in database B the char(n) columns do not compare correctly. Data Compare reports differences in about 10% of the rows even though the data in the rows are exactly the same. This is between database A and database B on the same sql2005 server both with compatibility set to 9.0. When I check the strings with TSQL functions Difference(), Datalength() and Len() the string functions return the exact same result. Is this a bug in Data Compare??
0 · Share on Twitter