MYSQL5.5 supports utf8mb4, and MYSQL5.1 does not support “utf8mb4”.
When connecting to the database, if utf8mb4 is specified, the error code that will appear is:
Error 1115: Unknown character set:’utf8mb4′
There will be utf8mb4 incompatibility.
So if you want to use utf8mb4 to store emoji characters, please upgrade as soon as possible
Read More:
- MySQL character set error resolution: err=Error 3988: Conversion from collation utf8mb4_unicode_ci into utf8_general_ci impo
- [Solved] mysql [ERR] 1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’
- [Solved] MySQL Error: Client does not support authentication protocol requested by server
- Navicat connected to Mysql error: Client does not support authentication protocol requested by server;
- MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
- Mysql5.7.18.1 Error 1054 (42S22): Unknown Column’password’ In’field List’ When Changing User Password
- linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- [Solved] Django configures MySQL Error: NameError: name ”_MySQL ‘is not defined
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- [Solved] MYSQL Error: unknown error 1130, unknown error 1045
- [Solved] public key is not available client side (option serverRsaPublicKeyFile not set)
- [Solved] Windows MYSQL Error: django.db.utils.OperationalError: (2026, ‘SSL connection error: unknown error number‘)
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “