解决SQL 的 Collation 问题:Cannot resolve collation conflict for equal to operation.
来源:互联网 发布:火炬之光mac版 编辑:程序博客网 时间:2024/04/29 23:19
http://bbs.csdn.net/topics/70144642
在涉及多表的联结查询中,如果联结字段采用不同的排序规则,则出现冲突
解决办法有四种:1、在查询时指定排序规则,这样无须对数据库进行任何修改
select * from a join b on a.aa=b.bb collate chinese_prc_ci_as --(可以任意指定一种sqlserver支持的排序规则)
2、修改联结字段的排序规则,使之统一
可以在企业管理器中,修改表的设计(打开表设计窗口->排序规则)
也可以用sql语句
alter table a ALTER COLUMN aa char(10) COLLATE Latin1_General_CI_AS
3、使用sql server的工具Rebuildm.exe 更改 Microsoft SQL Server2000 实例的排序规则设置
4、重新安装sql server,选择需要的排序规则
0 0
- 解决SQL 的 Collation 问题:Cannot resolve collation conflict for equal to operation.
- Cannot resolve collation conflict for equal to operation.
- Cannot resolve collation conflict for equal to operation
- Cannot resolve collation conflict for equal to operation.
- SQL语句进行left join的时候发生Cannot resolve collation conflict for equal to operation.错误 SQL语句进行left join的时候发生Cannot resolve collation
- Cannot resolve collation conflict for UNION operation.
- 如何解决错误Cannot resolve collation conflict for DISTINCT operation?
- sql左连接时发生字符集错误Cannot resolve the collation conflict between in the equal to operation.
- 解决SQL 的Cannot resolve collation conflict for column 6 in SELECT statement.报错
- "Cannot resolve collation conflict for column 1 in SELECT statement."
- Cannot resolve the collation conflict between "SQL_Latin1_Gen
- Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS"
- Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI"
- 解决办法: Cannot resolve the collation conflict between "Japanese_CI_AS" and "SQL_...
- Sql server中Collation conflict问题
- Sql server中Collation conflict问题
- Sql server中Collation conflict问题
- Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_L及由于排序规则不同导致查询结果为空的问题
- Low Memory Killer的原理
- 调用照相机和相册功能
- 检测发生死锁的sql语句
- Solving customer VDI boot storm without taking rip-and-replace approach
- xxx will be initialized after
- 解决SQL 的 Collation 问题:Cannot resolve collation conflict for equal to operation.
- php 验证码显示大小
- SVM(一)
- Awk 命令学习总结、AWk命令系列学习(linux shell)
- 10 个迅速提升你 Git 水平的提示
- 对一切有着莫名的恐惧
- What is a Desktop Virtualization Boot Storm?
- 彻底删除Exchange Server 2010
- Android布局规范