Forum Discussion
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 equal to operation.
Details:
DataSourceKind=SQL
DataSourcePath=kt-sql01;RptViews
Message=Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation.
Number=468
Class=16
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.
2 Replies
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.