本文共 594 字，大约阅读时间需要 1 分钟。

两个数据库的字符集不同，我们在进行union 等操作时，会出现字符集冲突错误．

例如： SELECT ISNULL (Report_No,’’) as ReportNo FROM SYSSCAN_WDC_ETS…SR_report_master UNION SELECT ISNULL (Report_No ,’’) as ReportNo FROM Inspection…MPI_Master C

–出现错误：

cannot resolve the collation conflict between “Chinese_Taiwan_Stroke_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation.

解决方案，用COLLATE 指定同一个字符集即可：

SELECT ISNULL (Report_No COLLATE SQL_Latin1_General_CP1_CI_AS,’’) as ReportNo FROM SYSSCAN_WDC_ETS…SR_report_master

UNION SELECT ISNULL (Report_No COLLATE SQL_Latin1_General_CP1_CI_AS,’’) as ReportNo FROM Inspection…MPI_Master

转载地址：http://fsmdi.baihongyu.com/