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/
Go to Top of Page

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/

Go to Top of Page

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/
Go to Top of Page
   

- Advertisement -