向数据库中传入中文字符报错

Error querying database. Cause: java.sql.SQLException: Illegal mix of collations (xxx) and (xxx)  for operation '='

百度：字符集问题

IDEA修改数据库字符集：

        第一种： （没试）设置idea连接数据库时使用的字符集_idea 怎么改字符集_weixin_44847713的博客-CSDN博客

        第二种：

# 修改表的编码
ALTER TABLE xyl.user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

# 查看表的编码信息
show variables like 'character_set_%';


character_set_client utf8mb4 
character_set_connection utf8mb4 
character_set_database utf8mb4 
character_set_filesystem binary
character_set_results utf8mb4 
character_set_server utf8mb4 
character_set_system utf8mb4 
# 修改命令，如
set character_set_client = 'utf8'