The utf8mb4 encoding is a superset of the utf8 encoding, is compatible with utf8, and can store 4-byte emoticon characters. The advantage of using utf8mb4 encoding is that you no longer need to consider the encoding and decoding of emoticon characters when storing and retrieving data. Change the database encoding to utf8mb4: 1. MySQL version The minimum MySQL version that supports utf8mb4 is 5.5.3+. If not, please upgrade to a newer version. 2. MySQL Driver 5.1.34 is available, the minimum cannot be lower than 5.1.13 SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; 3. Modify the MySQL configuration file Modify the MySQL configuration file my.cnf my.cnf is usually located in etc/mysql/my.cnf. Once found, please add the following content in the following three parts: [client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 Note the destination [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci init_connect = 'SET NAMES utf8mb4' 4. Restart the database and check the variables SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; It doesn't matter what collation_connection, collation_database, collation_server are. But it must be guaranteed System Variable Description These variables must be utf8mb4. 5. Database connection configuration In the database connection parameters: characterEncoding=utf8 will be automatically recognized as utf8mb4. You can also omit this parameter and it will be automatically detected. 6. Convert the database and the created tables to utf8mb4 Change the table encoding: ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8mb4 COLLATEutf8mb4_general_ci; Summarize The above is what I introduced to you on how to change the encoding of MySQL database to utf8mb4. I hope it will be helpful to you! You may also be interested in:
|
<<: Example of making XML online editor using js
Preface The Linux system is controlled by the sys...
There is currently a requirement that an operatio...
Preface: When we are making web pages, we often n...
The CSS counter attribute is supported by almost ...
Preface I believe that in the process of mobile t...
1. Analytical thinking 1. Eliminate the machine...
"Development is more than just writing code&q...
Table of contents 1. Closure 2. Closure usage sce...
1. Text around the image If we use the normal one...
Use indexes to speed up queries 1. Introduction I...
1.docker search mysql查看mysql版本 2. docker pull mys...
Now that we have finished the transform course, l...
There are two solutions: One is CSS, using backgro...
Table of contents 1. Introduction to NFS-Ganesha ...
MYSQL is case sensitive Seeing the words is belie...