Collation Conflict - SQL Server Forums

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

Transact-SQL (2005)

Collation Conflict

Author

Topic

gnaus
Starting Member

41 Posts

Posted - 2011-12-20 : 07:54:07

Dear reader

Can somebody help me with this collation conflict?

update dbo.Oefenomgeving$Geldzaken
set Opmerkingen=(select ConversieGeldzakenFinancieelBeheer.Opmerkingen from ConversieGeldzakenFinancieelBeheer
where dbo.Oefenomgeving$Geldzaken.[Client Code]= ConversieGeldzakenFinancieelBeheer.ClientnrQzorg)
where exists (select ConversieGeldzakenFinancieelBeheer.Opmerkingen from ConversieGeldzakenFinancieelBeheer
where dbo.Oefenomgeving$Geldzaken.[Client Code] collate Latin1_General_CS_AS
= ConversieGeldzakenFinancieelBeheer.ClientnrQzorg COLLATE SQL_Latin1_general_CP1_CI_AS

)

Error:

Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CS_AS" in the equal to operation.

Table dbo.Oefenomgeving$Geldzaken = Latin1_General_CS_AS

And

View ConversieGeldzakenFinancieelBeheer= Latin1_General_CS_AS

Thank you!

GN

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-12-20 : 08:01:46

Change the collation of one of the columns as follows:


where dbo.Oefenomgeving$Geldzaken.[Client Code] collate SQL_Latin1_general_CP1_CI_AS
= ConversieGeldzakenFinancieelBeheer.ClientnrQzorg COLLATE SQL_Latin1_general_CP1_CI_AS

where dbo.Oefenomgeving$Geldzaken.[Client Code] collate Latin1_General_CS_AS
= ConversieGeldzakenFinancieelBeheer.ClientnrQzorg COLLATE Latin1_General_CS_AS

I, of course, don't know which one would be appropriate for your business requirements

gnaus
Starting Member

41 Posts

Posted - 2011-12-20 : 08:25:06

thanks , it works!! (I already tried that but I forgot that I had to place the formula at two places in the formula and not only in the last two sentences (but also the "where" above) greetings,

GN

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-20 : 08:57:01

quote:
Originally posted by gnaus

thanks , it works!! (I already tried that but I forgot that I had to place the formula at two places in the formula and not only in the last two sentences (but also the "where" above) greetings,

GN

seriously didnt understand why you were explicitly trying to change collation in on statement though!

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources