Error solution when inserting MySQL database due to WeChat nickname with symbol, nickname mysql

An error occurred when inserting a MySQL database due to a nickname with symbols.

Mysql utf8 encoding can contain up to three bytes, while Emoji expressions or some special characters are 4 bytes.

Therefore, an error occurs when a nickname with an emoticon is inserted into the database.

ModifyMySQLThe solution is as follows:

1. Find my. ini in the mysql installation directory and make the following changes:

[Mysqld] character-set-server = utf8mb4 [mysql] default-character-set = utf8mb4

2. Restart the mysql service.

3. modify a table

Alter table name convert to character set utf8mb4 COLLATE utf8mb4_bin;

The above is a small series of Solutions to errors caused by the insertion of MySQL database due to nicknames with symbols. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!