Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operat

提示：Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation ‘find_in_set’

---

一、MYSQL8？

默认的排序规则：utf8mb4_0900_ai_ci

二、目前的自定义的数据库表

utf8mb4_general_ci

1.报错sql

代码如下（示例）：

SELECT
 id,
 #level,
 CODE,
 parent_id,
NAME 
FROM
 (
 SELECT
  t1.*,
 IF
  ( FIND_IN_SET( parent_id, @pids ) > 0, @pids := CONCAT( @pids, ',', id ), '0' ) AS ischild 
 FROM
  ( SELECT * FROM auth_organization AS t WHERE t.STATUS = '1' ) t1,
  (
  SELECT
  @pids := 1557259013072052225) t2 
 ) t3 
WHERE
 ischild != '0' UNION
SELECT
 id,
 #level,
 CODE,
 parent_id,
NAME 
FROM
 auth_organization 
WHERE
 id = 1557259013072052225
ORDER BY NAME 
#order by level, name

错误

代码如下（示例）：

1267 - Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation 'find_in_set'

处理
show variables like ‘%coll%’;
set global collation_connection = ‘utf8mb4_general_ci’;

先执行：
set collation_connection = ‘utf8mb4_general_ci’;

---