为什么会出现此错误：在此查询上，操作"="的排序规则(utf8_general_ci，隐式)和(utf8_bin，无)的非法混合？

Question

查询：

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

[Err]167-操作'='的排序规则(utf8_general_ci，IMPLICIT(和(utf8-bin，NONE(非法混合

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这样的CONCAT函数中混合字符集编码(utf8_general_ci，utf8_bin(。