Solution to Incorrect string value in MySQL

Many friends will report the following error when inserting Chinese characters using MySQL:

This is because we did not specify a character set. In the computer, characters are stored in a binary system. Similarly, Chinese characters also need to be stored in binary. Then we need to specify a table (representation rules: which Chinese characters correspond to which binary). Generally, utf8 is more commonly used. Of course, you can also specify utf8mb4, which can be used to represent more special symbols, such as emoticons. However, in our daily use, utf8 is sufficient. Let's take the utf8 character set as an example:

First find the MySQL program in the start menu:

Just right-click any of these two, then click More-Open File Location:

Also right-click any of them, then click Properties, and find the path corresponding to my.ini in the target path:

Then right-click my.ini and open it in Notepad

Write utf8 after the equal sign under [mysql]

Similarly, add utf8 to the right of the equal sign under [mysqld] (note that there should be no spaces on both sides)

Pay special attention! ! !
1. After adding utf8, delete the pound sign in front of these two statements to prevent the system from mistaking them for comments! ! !
2. If you are afraid of making mistakes before modifying, you can back up my.ini in advance (copy and paste)

After the modification, we can restart the computer, so that there will be no error when adding Chinese characters in the future (note here that before the modification, when inserting Chinese characters in the originally created database, an error will still be reported, and we should create a new database)

This is the end of this article about the solution to Incorrect string value in Mysql. For more related Mysql Incorrect string value content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!