SQL Server Error Msg 468, Level 16, State 9: Cannot resolve the collation conflict

Cannot resolve the collation conflict
Cannot resolve the collation conflict

SQL Server Error Message :

 


Msg 468, Level 16, State 9, Procedure sp_Sales_Invoice, Line 209
Cannot resolve the collation conflict between “SQL_Latin1_General_CP850_CI_AS”
and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

How to resolve :


SELECT Item
FROM Table_A
INNER JOIN Table_B
ON Table_A.ItemA COLLATE DATABASE_DEFAULT = Table_B.ItemB COLLATE DATABASE_DEFAULT

Leave a comment

comments

Be the first to comment on "SQL Server Error Msg 468, Level 16, State 9: Cannot resolve the collation conflict"

Leave a comment

Your email address will not be published.


*