mysql - 为什么这个错误 : Illegal mix of collations (utf8_general_ci, IMPLICIT) and (utf8_bin,NONE) for operation '=' , ON THIS QUERY?

Question

查询:

select *,
       (@page_path = concat(
           @page_path,
           chk_v_application_tree.alias
       )) as path
from chk_v_application_tree 

[Err] 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_bin,NONE) for operation '='

Answer 1

尝试:

select *,
       (@page_path = concat(
           CONVERT(@page_path USING utf8) COLLATE utf8_bin,
           chk_v_application_tree.alias
       )) as path
from chk_v_application_tree

因为您不能在 CONCAT(utf8_general_ci, utf8_bin) 等 CONCAT 函数中混合使用字符集编码。