Forum Discussion
Solved
error when merging tables
Any help on this particular error? I don't sql. DataSource.Error: Microsoft SQL: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CS_AS" in the e...
kcantor This error is common sql database issue when joining different objects for which you cant change collation type. Use either of below queries to overcome collation issue.
Select * from A join B on A.text = B.text COLLATE Latin1_General_CI_AS
or
Select * from A join B on A.text = B.text COLLATE DATABASE_DEFAULT
Simple work around is to add an index column.
kcantor This error is common sql database issue when joining different objects for which you cant change collation type. Use either of below queries to overcome collation issue.
Select * from A join B on A.text = B.text COLLATE Latin1_General_CI_AS
or
Select * from A join B on A.text = B.text COLLATE DATABASE_DEFAULT