Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satheesh
Posting Yak Master
152 Posts |
 Posted - 2011-04-19 : 11:50:14
|
| Dear All,I try to execute a simple query [select * from cst inner join filter on cst.cstId = filter.cstid ]i stuck with the follwing errorCannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.What may be the reason and how to resolve this.Any help would be highly appreciated.Thanks in advance.Regards,SG |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-19 : 11:55:57
|
| select * from cst inner join filter on cst.cstId COLLATE SQL_Latin1_General_CP1_CS_AS = filter.cstid COLLATE SQL_Latin1_General_CP1_CS_AS(error was occuring because both column were created with different collation)--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
Collation Conflict