Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation.

Description:

In this example we explain that how to resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation. or how to resolve the collation conflict and check collate in SQL Server. or cannot resolve the collation conflict between in the union operation. Or cannot resolve collation conflict in union select.

This is the error raised when we comparing two columns of different databases. If the column have the different collation it will generate the error like “Cannot resolve the collation conflict for equal to operation”  so to resolve the collation conflict issue add the following keyword around “=” operator in your SQL Query like show the below example.

Query:

SELECT ID
FROM ItemsTable
INNER JOIN AccountsTable
WHERE ItemsTable.Collation1Col COLLATE DATABASE_DEFAULT
= AccountsTable.Collation2Col COLLATE DATABASE_DEFAULT