-
Title
Getting the "Cannot resolve the collation conflict" error. -
Description
The follwoing error occurs when trying to analyze links using Link Tracking: "Cannot resolve the collation conflict between "Latin1_General_CI_AS_KS_WS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."
-
Resolution
The issue is related to difference in collation between SQL Server and Link Tracking database.
To troubleshoot the issue, find out what collation is used for SQL Server and Link Tracking database and contact Quest Support.
-
Defect ID
TFS0105766 -
Additional Information
A collation itself specifies the rules for how strings of character data are sorted and compared. The rules for sorting data vary depending on the language and locale. For example if you was to use a Lithuanian collation, the letter "Y" would appear between "I" and "J" if sorted. And if using the traditional Spanish collation "ch" would be sorted at the end of a list of words beginning with "c".