Just Learned - Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation

Jul 12 2012 12:00AM by RKA

While writing a query with joining two tables from two different dbs, a collation error was encountered. 'Cannot resolve collation conflict for equal to operation.' Fix:

add keyword COLLATE DATABASE_DEFAULT after join .

SELECT <columnname>
FROM  <dbname1>.<dbo>.table1 t1
INNER JOIN<dbname1>.<dbo>.table1 t2
ON t1.colx = t2.coly COLLATE DATABASE_DEFAULT

Read More.. [27 clicks]

Published under: General Technology Tips · · · ·

RKA

91 · 2% · 598

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	Submit

1 Comments

Please note that changing the collation changes the way SQL Server interprets string values - the result of a string comparison after changing the collation may be different than expected.

commented on Jul 14 2012 2:06PM

Nakul Vachhrajani

4 · 33% · 10575

Your Comment

Sign Up or Login to post a comment.

"Quick fix to SQL Server collation error - Cannot resolve collation conflict for equal to operation" rated 5 out of 5 by 4 readers