错误信息:
[10501]SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
解决方法:
找出相关字段执行 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
错误信息:
[10501]SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
解决方法:
找出相关字段执行 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci