java - How to solve the problem of mixed collation of mysql;

Question

I use Spring JPA to operate the database mysql. I have set it when I first created the database.
default-character-set=utf8mb4
default-collation=utf8mb4_general_ci
But I still get an error after running:
java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

Answer 1

Has the client database connection string been configured?

jdbc.url=jdbc:mysql://localhost/test?characterEncoding=utf8mb4