resolve the 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 2012 Forums

Transact-SQL (2012)

resolve the collation conflict

Author

Topic

ori_davidson
Starting Member

15 Posts

Posted - 2014-09-15 : 14:43:39

Hello,
I have this problem. Will love to get some HELP!
Thnx,
ORI

QUERY:
update W
set w.U_Shelf = T.location
from dbo.OITM as W inner join [SERVER-WMS].SCEXPERT.dbo.vLoniSkuPrefLoc AS T on t.SKU=w.itemcode

ERROR:
Msg 468, Level 16, State 9, Line 3
Cannot resolve the collation conflict between "SQL_Latin1_General_CP850_CI_AS" and "Hebrew_CI_AS" in the equal to operation.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-15 : 15:09:25

Looks like the databases are using a different collation. Add the COLLATE option to the join condition to resolve.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

ori_davidson
Starting Member

15 Posts

Posted - 2014-09-16 : 02:02:50

I'm sorry,but, HOW??

quote:
Originally posted by tkizer

Looks like the databases are using a different collation. Add the COLLATE option to the join condition to resolve.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2014-09-16 : 02:14:31

Something like this:

update W
set w.U_Shelf = T.location 
from dbo.OITM as W inner join [SERVER-WMS].SCEXPERT.dbo.vLoniSkuPrefLoc AS T on t.SKU=w.itemcode COLLATE SQL_Latin1_General_CP850_CI_AS

Harsh Athalye
http://www.letsgeek.net/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources