关闭

Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS"

标签: collationconflictdatabaseuser
3842人阅读 评论(1) 收藏 举报
分类:

Executed as user: NT AUTHORITY\SYSTEM. Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468).  The step failed.


解决方式:

on a.[Column1]= b.[Column2]

à

on a.[Column1] COLLATE Chinese_PRC_CI_AS= b.[Column2]


或者下面也可以

on a.[Column1] Collate Database_Default = b.[Column2]


0
0
查看评论

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI"

SQL SERVER 做联合查询时。 遇到 排序规则不匹配。 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI&qu...
  • lichxi1002
  • lichxi1002
  • 2015-01-30 11:44
  • 2527

the collation conflict between "chinese_prc_ci_as" and "sql_latin1_general_cp1_ci_as" in the equal t

昨天升级存储过程后发现报这个错误 cannot resolve the collation conflict between "chinese_prc_ci_as" and "Chinese_Taiwan_Stroke_CI_AS_WS" in the ...
  • xiuhaijuanqiang
  • xiuhaijuanqiang
  • 2013-08-14 16:13
  • 4578

SQL Server: collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"

Issue: Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to o...
  • XinYaping
  • XinYaping
  • 2014-03-13 12:06
  • 7176

解决办法: Cannot resolve the collation conflict between "Japanese_CI_AS" and "SQL_...

问题描述:今天在执行创建视图操作的时候,出现了如下错误 Cannot resolve the collation conflict between "Japanese_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in t...
  • dietime1943
  • dietime1943
  • 2017-06-01 18:34
  • 2236

sql左连接时发生字符集错误Cannot resolve the collation conflict between in the equal to operation.

SQL语句进行left join的时候发生以下错误: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI_AI" i...
  • mx5721
  • mx5721
  • 2012-09-11 17:25
  • 4076

无法解决 equal to 操作中 "Chinese_Taiwan_Stroke_CI_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突。

select D.departmentid,D.departmentname,E.DepNo,E.DepName from dbo.departmenta as D inner join srv_lnk.testhr.dbo.employee_dep as E on D.departmenti...
  • a363096s
  • a363096s
  • 2014-03-06 15:43
  • 1002

Sql server中Collation conflict问题

(转载自 http://www.cnblogs.com/michaelxu/archive/2009/10/19/1585775.html ) 今天在做data migration时写了一个跨数据库查询的语句: select d.ID as SGPID,'S' as SGPT...
  • soudog
  • soudog
  • 2012-05-07 15:45
  • 2230

解決:無法解析 equal to 作業中 "Chinese_Taiwan_Stroke_CI_AS" 與 "Chinese_PRC_CI_AS" 之間的定序衝突

最近在使用连接服务器跨数据库查询数据的时候出现一下问题: 無法解析 equal to 作業中 "Chinese_Taiwan_Stroke_CI_AS" 與 "Chinese_PRC_CI_AS" 之間的定序衝突 很明显是繁体数据库和简体数据库...
  • loeley
  • loeley
  • 2012-04-13 10:36
  • 9306

Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_AS"

Executed as user: NT AUTHORITY\SYSTEM. Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_Taiwan_Stroke_CI_...
  • chenghaibing2008
  • chenghaibing2008
  • 2012-04-01 10:35
  • 3842

Cannot resolve collation conflict for equal to operation.

 SQL 2000的Cannot resolve collation conflict for equal to operation.问题。 在SQL 2000查询的时候有时候会出这种错误。 这是因为排序冲突了的原因  只要在Where 条件的=两边加上“CO...
  • zhang116868
  • zhang116868
  • 2009-11-23 17:01
  • 1862
    个人资料
    • 访问:834534次
    • 积分:12172
    • 等级:
    • 排名:第1443名
    • 原创:471篇
    • 转载:30篇
    • 译文:0篇
    • 评论:56条
    文章分类