常見錯誤

• 無法解析 equal to 作業中 "Chinese_Taiwan_Stroke_CS_AS" 與 "Chinese_Taiwan_Stroke_CI_AS" 之間的定序衝突。

  • COLLATE Chinese_Taiwan_Stroke_CI_AS

    • 例

SELECT *

FROM baccount_DEPT_BAS t1

LEFT JOIN baccount t2 ON t1.DEP_CHIEF = t2.id COLLATE Chinese_Taiwan_Stroke_CI_AS

LEFT JOIN baccount t3 ON t2.agent = t3.id

ORDER BY t1.上層階級_一般員工