SQL Server conflict between “Chinese_PRC_CI_AS_WS“ and “Albanian_100_BIN“ in the equal to operation.

由于排序规则不同，导致 join 时报错：
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS_WS" and "Albanian_100_BIN" in the equal to operation.

由于排序规则不同，导致 union all  时报错：
Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict between "Chinese_PRC_CI_AS_WS" and "Albanian_100_BIN" in UNION ALL operator.

---

在join 或union all 时加上  COLLATE Chinese_PRC_CI_AS_WS 或者COLLATE Albanian_100_BIN 就可以了

①、加上  COLLATE Chinese_PRC_CI_AS_WS

select * from tmpTB_1 t1 left join tmpTB_2 t2 on t1.Name COLLATE Chinese_PRC_CI_AS_WS = t2.Name

①、加上  COLLATE Albanian_100_BIN

select * from tmpTB_1 t1 left join tmpTB_2 t2 on t1.Name = t2.Name COLLATE Albanian_100_BIN