Joining two tables with different collation settings

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Joining two tables with different collation...

Joining two tables with different collation settings

Rate Topic

Display Mode

Topic Options

Author

Message

deepthi818

Posted Monday, May 03, 2010 11:24 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:53 AM
Points: 13, Visits: 62

Can we execute a join on two tables with different collation settings? Why or why not?

"Cannot resolve collation conflict for equal to operation." -Does this error always occur or are there any specific cases when this error occurs...? Is there any workaround or this problem?

Would be great if someone would clarify my doubts...

Post #915071

Bhuvnesh

Posted Tuesday, May 04, 2010 1:18 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Below link contains explanation as well as workaround for your problem
http://www.developmentnow.com/g/113_2006_7_0_0_797273/Cannot-resolve-collation-conflict-for-equal-to-operation-.htm

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #915106

deepthi818

Posted Tuesday, May 04, 2010 5:01 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:53 AM
Points: 13, Visits: 62

Thanks for replying..

Post #915189

Bhuvnesh

Posted Tuesday, May 04, 2010 5:30 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

deepthi818 (5/4/2010)

Thanks for replying..

still you need any help , you are welcome Smile

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #915206

Animal Magic

Posted Tuesday, May 04, 2010 6:36 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:40 AM
Points: 983, Visits: 13,348

deepthi818 (5/3/2010)

It will happen on any character based fields. So (n)(var)char etc as it needs to compare the codepages. Numeric you will be fine with.

Is this a production database or just in test? If the collation issue has been caused by error it may be wise to just setup the database again.

I see the issue all the time when the regional settings of the machine are left as US and SQL installed with default collation. Then on another server the regional settings will be correctly set to UK and this uses a different codepage. Pain in the arse to say the least!

Post #915246

deepthi818

Posted Tuesday, May 04, 2010 9:22 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:53 AM
Points: 13, Visits: 62

I just encountered the situation while i was testing... not very critical.. Thanks for helping guys!

Post #915402

MannySingh

Posted Tuesday, May 04, 2010 1:53 PM

SSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 1:10 PM
Points: 646, Visits: 729

checkout this solution:
http://www.dbanation.com/?tag=collation

Maninder
www.dbanation.com

Post #915632

« Prev Topic | Next Topic »

Permissions