无法解决"Latin1_General_CI_AS"与"Latin1_General_CI_AS"之间的排序规则冲突.和"SQL_Latin1_General_CP1_CI_AS"；在等于操作中. [英] Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

问题描述

Select Student_ID,SName,Course,Branch,Year,Semester,Section,Fee from ExamEntry1 where 
Course='B-TECH'and Branch='CSE' and Year ='III' and semester='I' and Section='A' and
Student_ID not in(select StudentID from StudentFeeDetails)

我收到此错误-

在等于操作中，无法解决"Latin1_General_CI_AS"和"SQL_Latin1_General_CP1_CI_AS"之间的排序规则冲突.

I got this error -

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

What does this means?

推荐答案

创建表时，可以为每一列设置整理值，整理用于指定想要的数据敏感度此列中的数据(例如区分大小写，日语KANA字符等).在比较2列(如果归类值不匹配)时，如何比较这2列?

检查以下链接以获取解决方案.

http://blog.sqlauthority .com/2007/06/11/sql-server-cannot-resolve-collat​​ion-conflict-for-equal-to-operation/ [

When you create a table you can set Collate Values for every column, the Collate is used to specify what kind of data sensivity you want for the data in this column, (like Case sensetive, Japanese KANA characters, etc). while comparing 2 columns if the collate value is not matching, how can you compare these 2 columns ?

check the below link to get the solution.

http://blog.sqlauthority.com/2007/06/11/sql-server-cannot-resolve-collation-conflict-for-equal-to-operation/[^]

这篇关于无法解决"Latin1_General_CI_AS"与"Latin1_General_CI_AS"之间的排序规则冲突.和"SQL_Latin1_General_CP1_CI_AS"；在等于操作中.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！