sql报错Illegal mix of collations

select company_name from upload_record_detail where company_name in ('晋县高贤纸箱𠂆_否_是','邢台欧乐建筑工程有限公司_否_是')

查询报错:

[HY000][1270] Illegal mix of collations (utf8_general_ci,IMPLICIT), (utf8mb4_0900_ai_ci,COERCIBLE), (utf8mb4_0900_ai_ci,COERCIBLE) for operation ' IN '

修改为:

select company_name from upload_record_detail where
    company_name in (
    <foreach collection="list" item="obj" separator=",">
      #{obj} COLLATE utf8mb4_0900_ai_ci
    </foreach>
    ) and del_flag = 0

报错

MySql报 java.sql.SQLException: Incorrect string value 乱码解决方法

修改字符集