对于这个错误,我得到了几个答案,但在我的情况下没有任何结果
update students set studentID ='001093' where studentID ='1578093'
当我尝试在sql db中更新时,出现以下排序规则错误:
Cannot resolve the collation conflict between
"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal
to operation.
我试过的
update students set studentID COLLATE SQL_Latin1_General_CP1_CI_AS ='001093' where studentID ='1578093' COLLATE SQL_Latin1_General_CP1_CI_AS
请帮助解决这个问题…我知道我们有足够的副本,但没有一个解决方案是为我工作
2条答案
按热度按时间bbmckpt71#
排序规则应应用于字符串值,而不是列:
tcbh2hod2#
早安,程序员。尝试应用collate数据库默认值: