【操作】sql聯(lián)合查詢

SET @m='1001';
select t.TRADE_S,t.TRADE_T,d.TRANS_N,d.TRANS_S,d.* 
from db.t_main t
left join db.t_item d on t.O_ID = d.O_ID
where t.O_NO = @m;

【結(jié)果】查詢報錯：
Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

【解決】在變量后指定排序類型、字符編碼
COLLATE utf8mb4_unicode_ci

SET @m='1001';
select t.TRADE_S,t.TRADE_T,d.TRANS_N,d.TRANS_S,d.* 
from db.t_main t
left join db.t_item d on t.O_ID = d.O_ID
where t.O_NO = @m COLLATE utf8mb4_unicode_ci;