Cannot resolve the collation conflict.无法解析等号两边的中文简体和中文繁体字符集

作者:C/S原创发布日期:2011/03/24 23:56:01

Cannot resolve the collation conflict.无法解析等号两边的中文简体和中文繁体字符集

很多企业的用户群跨越两岸三地，使用语言有简繁英三种，而数据库字符集一般是定义为“Database Default"，
当不同字符集的数据之间建立关联查询时会出现下图中所示的错误。

Cannot resolve the collation conflict between "Chinese_Taiwan_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in the equal to operation.

无法解析等号两边的中文简体和中文繁体字符集。

解决办法：

SELECT A.* FROM DATA_A A,B.* FROM DATA_B B

WHERE A.VALUE COLLATE Chinese_PRC_CI_AS = B.VALUE COLLATE Chinese_PRC_CI_AS

// 来源:www.CSFramework.com, C/S结构框架学习网

参考文档：

SQL：Cannot resolve the collation conflict (字符集冲突)
XtraReport 报错:Report scripts were found in the application while the script execution is disabled.
The Database principal owns a schema in the database
打开设计窗体报错:To prevent possible data loss before loading the designer
CSFramework.Authentication 软件授权证书管理系统|C/S开发框架
CSFramework.Authentication 软件授权证书管理系统|C/S开发框架
XtraReport:annot execute report scripts because the application does not include required libraries
Win10安装TortoiseGit 2.14，The error code is 2503 解决方案
C# 对象克隆 TOut ObjectHelper.Clone |C/S开发框架
[电子商务]新普商城XpShop 7.0 正式版_xpshop_clothes_7.0_rc2-源码下载
[电子商务]新普服饰行业网上商店系统XpShop 7.0 RC2_xpshop_clothes_7.0_rc2-源码下载
软件开发与设计 - MIS-管理信息系统-[其他类别]TheBeerHouse微软经典asp.net
软件开发与设计 - BBS-电子布告栏系统-[博客空间]YetAnotherForum.Net 中文完美汉化增强版
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the s
调用WebApi接口POST操作失败Unable to connect to the remote server
The server factory could not be located for the given input: Microsoft.Owin.Host.HttpListener