Error:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘utf8’

How to Solve:

database formate

Default Character Set = utf8mb4

Default Collation = utf8mb4_unicode_ci

Just reinsert the data

Similar Posts:

• What is the difference between utf8mb4 Unicode Ci and UTF8 general CI in MySQL database?
• The solution of job failed to start when modifying MySQL character encoding
• [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
• For the problem of establishing SSL connection in mysql, set usessl = false to explicitly disable SSL, or set usessl = true
• [Solved] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
• [Solved] MySQL Error: ERROR 1273 (HY000) at line 199: Unknown collation: ‘utf8mb4_0900_ai_ci’
• [Solved] JMeter Use the JDBC linker Error: Unknown initial character set index ‘255’ received from server.initial client character
• [Solved] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.6…
• SELECT list is not in GROUP BY clause and contains nonaggregated column
• Lock wait timeout exceeded; try restarting transaction-Mysql [How to Solve]