Cannot resolve collation conflict between "Chinese_Taiwan_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in UNION ALL operator occurring in SELECT statement column 1.

Cannot resolve collation conflict between "Chinese_Taiwan_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in UNION ALL operator occurring in SELECT statement column 1.

Cannot resolve collation conflict between "Chinese_Taiwan_Stroke_CI_AS" and "Chinese_PRC_CI_AS" in UNION ALL operator occurring in SELECT statement column 1.

解决方案：

COLLATE Chinese_PRC_CI_AS

例子：

SELECT A.Name  FROM   A 

WHERE A.Code  COLLATE Chinese_PRC_CI_AS in （select A_Code COLLATE Chinese_PRC_CI_AS from  B  ）

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/panjinzhao/p/11309439.html