Resolving 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

General SQL Server Forums

New to SQL Server Programming

Resolving Collation Conflict

Author

Topic

bielen
Yak Posting Veteran

97 Posts

Posted - 2008-09-15 : 15:27:04

I'm in the process of moving various scripts from SQL2000 to 2005.

I have the following SQL statement:

SELECT QA_FailedVerify.WeekEndingDate
FROM QA_FailedVerify
INNER JOIN
QA_Product_Groups ON QA_FailedVerify.PRODUCT = QA_Product_Groups.productName
WHERE (QA_Product_Groups.groupName = 'TestProduct') AND (QA_FailedVerify.ReleaseType = 'M')
GROUP BY QA_FailedVerify.WeekEndingDate
ORDER BY QA_FailedVerify.WeekEndingDate

The scripts works fine in SQL 2000, but SQL 2005, I receive the following error message:

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_Prf_CP1_CI_AS" in the equal to operation.

The A_FailedVerify.PRODUCT field is varchar(50) and QA_Product_Groups.productName is nvarchar(50). I tried working with COLLATE, but its not working.

Any suggestions?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-15 : 15:28:57

Show us what you tried with COLLATE.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-15 : 23:54:19

just collation of one side column to be equal to other side column using
leftCol=rightcol collate <left collation>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources