In Microsoft SQL Server, collation can be set at the column level.
Error message 'Cannot resolve collation conflict for equal to operation' arises when comparing two columns that have different collations. For example:
SELECT ID
FROM ItemsTable
INNER JOIN AccountsTable
WHERE ItemsTable.CollationOneCol = ItemsTable.CollationTwoCol
If ItemsTable.CollationOneCol and ItemsTable.CollationTwoCol have different collation, it will generate the above error message.
Component: EUREKA:Object-Admin Edition
To resolve the collation conflict at the query level, add the following keywords around the "=" operator.
SELECT ID
FROM ItemsTable
INNER JOIN AccountsTable
WHERE ItemsTable.CollationOneCol COLLATE DATABASE_DEFAULT = ItemsTable.CollationTwoCol COLLATE DATABASE_DEFAULT
Collation can affect the following areas: