Sujeet Raman

Sujeet Raman

  • 752
  • 927
  • 354.1k

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_

Aug 3 2020 8:51 AM
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?? 

Answers (6)