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  )
 

 

posted @ 2019-08-06 15:48  纵一苇之所如-  阅读(729)  评论(0编辑  收藏  举报