Skip to content

Instantly share code, notes, and snippets.

@dolt131943

dolt131943/gist:cc88e47d27db9216fe450f1e5e32e2d5

Created October 12, 2018 07:32
Show Gist options
  • Save dolt131943/cc88e47d27db9216fe450f1e5e32e2d5 to your computer and use it in GitHub Desktop.
Save dolt131943/cc88e47d27db9216fe450f1e5e32e2d5 to your computer and use it in GitHub Desktop.
Download ZIP
java.sql.SQLException: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
Raw
gistfile1.txt
1. mysql create database use utf8mb4 collation utf8mb4_general_ci, and then import tables with charset=utf8mb4 with out setting collation;
2. the imported tables has use the default utf8mb4 collation utf8mb4_0900_ai_ci but not the database used;
solution: change database collation to utf8mb4_0900_ai_ci, solved the above problem.
@tinarooot
Copy link

hello，Solve it？

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment