Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_

Sujeet Raman

hi i am trying to update my table with a single update query

update students set studentID ='001093' where studentID ='1578093'

but getting this error

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

how can fix this in query??

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dhruval Dave6y ago
I found few references, Go through it and do let me know if it still fails:
1) https://social.msdn.microsoft.com/Forums/sqlserver/en-US/866efc20-8d84-4627-b574-6cc66d659396/receiving-collation-conflict-between-quotsqllatin1generalcp1ciasquot-and?forum=sqldatabaseengine
2) http://www.sqlusa.com/bestpractices/changecollation/
Laxmidhar Sahoo6y ago
Hi

Go through the link
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/866efc20-8d84-4627-b574-6cc66d659396/receiving-collation-conflict-between-quotsqllatin1generalcp1ciasquot-and?forum=sqldatabaseengine

Thanks and regards
Sujeet Raman6y ago
Tried that also..still i am getting the same error :(
Varun Setia6y ago
Try Append "COLLATE SQL_Latin1_General_CP1_CI_AS" or "COLLATE Latin1_General_CI_AI" after where clause
Sujeet Raman6y ago
how would i impliment in this query..i got diffrent examples like this..but nothing works
Varun Setia6y ago
Hi,

There is issue with database collation version set, might be due to old version.

Check this

https://stackoverflow.com/questions/52476275/mssql-collation-on-update-query