星空网 > 软件开发 > ASP.net

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

ErrorMessage

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

查看SQL Server的Collation

SELECT SERVERPROPERTY ('Collation')

Solution

1. 在安装SQL Server的时候Collation都选择Latin1_General(拉丁,不带100的那个)

2. 如果已经安装了SQL Server的话,那就在Database的属性下修改吧

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




原标题:Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_100_CI_AS in the equal to operation.

关键词:sql

sql
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流