Error in sql server collation conflict

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Error in sql server collation conflict

Author

Topic

roxcy
Yak Posting Veteran

58 Posts

Posted - 2007-06-26 : 08:14:42

I am facing the Follwing error:
Cannot resolve the collation conflict between "Latin1_General_BIN" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Follwing is my Code:
code]select * from #temp_Table a
where ltrim(rtrim(Model_ID))+''+ltrim(rtrim(Set_Serial_Number)) in
(select ltrim(rtrim(b.Model_SerialNo)) from #temp_Table2 b where b.Auto_Id=1)[[/code]

So Please help me to proper solutions
Thank's

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-26 : 08:27:50

The collation seems to be different for both temp tables.

Try this:

Select * from #temp_Table a
where ltrim(rtrim(Model_ID))+''+ltrim(rtrim(Set_Serial_Number)) collate SQL_Latin1_General_CP1_CI_AS in
(select ltrim(rtrim(b.Model_SerialNo)) collate SQL_Latin1_General_CP1_CI_AS from #temp_Table2 b where b.Auto_Id=1)

Please note that if you want case-sensitive comparison, use binary collation.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources