Sql server中Collation conflict问题
来源:互联网 发布:淘宝网购手机 编辑:程序博客网 时间:2024/05/16 10:09
SQL语句查询时
select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code=B .DMCode
结果在运行时碰到这样一个问题,问题描述:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
到网上搜了一下,了解了问题产生的原因,原来是两个数据库的collation不一致导致的,将查询语句改成如下:
select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code collate chinese_prc_ci_as =B .DMCode
select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code=B .DMCode
结果在运行时碰到这样一个问题,问题描述:
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation.
到网上搜了一下,了解了问题产生的原因,原来是两个数据库的collation不一致导致的,将查询语句改成如下:
select A.Code,A.Name,a.Systemcode,B.ID,B.LogType,B.DMCode,B.IP,B.Department,B.CreateBy,B.CreateTime
from DM_Document_TD as A left join DM_LOG_TD as B
on A .Code collate chinese_prc_ci_as =B .DMCode
- Sql server中Collation conflict问题
- Sql server中Collation conflict问题
- Sql server中Collation conflict问题
- SQL Server: collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Sql server中Collation …
- 解决SQL 的 Collation 问题:Cannot resolve collation conflict for equal to operation.
- SQL Server Collation介绍
- 如何修改SQL Server 中数据库的Collation
- SQL SERVER 2005 COLLATION 详解
- Sql server 日记 (Collation)
- sql server 2005 Collation 冲突
- SQL Server Collation引发的惨案
- SQL Server 更改DB的Collation
- SQL Server 学习笔记之Collation(校对)
- 解决SQL 的Cannot resolve collation conflict for column 6 in SELECT statement.报错
- SQL Collation
- 更改SQL Server服务器默认collation设置(Changing Server Default Collation )
- SQL语句进行left join的时候发生Cannot resolve collation conflict for equal to operation.错误 SQL语句进行left join的时候发生Cannot resolve collation
- 给Derek的一封信
- Ajax使用Action中返回的Json数据的完整实例(二):action内将一个实体对象转化为json并返回
- 怎样让Oracle的存储过程返回结果集
- ruby 代码示例备份
- android 开发中判断网络是否连接的代码
- Sql server中Collation conflict问题
- 是不是爱情
- UIScrollView用法
- yii checkBoxList 横向排列
- MySQL日期时间函数大全
- java冒泡排序代码
- Settings中布局主题定义。
- applicationContext.xml cannot be opened because it does not exist
- [模板]最长有序子序列