日志报错Caused by: java.sql.SQLException: Illegal mix of collations (utf8mb4_0900_ai_ci,COERCIBLE) and (gbk_chinese_ci,IMPLICIT) for operation ‘UNION’,定位到SQL,拿sql
执行报错 Illegal mix of collations (utf8mb4_0900_ai_ci,COERCIBLE) and (gbk_chinese_ci,IMPLICIT) for operation ‘UNION’
解决方法1:修改编码
解决办法2:对中文编码用CAST进行转换