• notice
  • Congratulations on the launch of the Sought Tech site

WeChat nickname with symbols cause an error when inserting a mysql database

Mysql's utf8 encoding is up to 3 bytes, while Emoji or some special characters are 4 bytes.

This will cause errors when inserting emoticon nicknames into the database.

Just modify the encoding of MySQL, the solution is as follows:

1.Find my.ini in the installation directory of mysql, and make the following modifications:


2 Restart the mysql service

3 Modify table

ALTER TABLE table name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

The above is the solution introduced by the editor to you when the WeChat nickname with symbols causes errors when inserting into the MySQL database.I hope it will be helpful to you.If you have any questions, please leave me a message.The editor will reply to you in time.of.Thank you very much for your support to the website!


Technical otaku

Sought technology together

Related Topic


Leave a Reply