Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’
方案一:
修改数据库字符集
collation_connection
character_set_server
后重启
方案二:
如果不想重启数据库可在jdbc链接后增加connectionCollation
方案三:
connectionInitSqls -> set names utf8mb4;