A permanent solution to MYSQL's inability to recognize Chinese

In most cases, MySQL does not support Chinese when it is just installed. This is due to encoding issues. We can permanently enable MySQL to recognize Chinese by modifying the configuration file.

First we need to display the hidden files in the folder (as shown in the picture)↓

In MySQL 5.5 and older versions, most configuration files are in the installation directory. The my.ini file in the figure below is what we need.

In MySQL 5.7 and above, the configuration file is located in the following position

We just need to open my.ini and change the default encoding of the code segment below to utf8 and save it.

If it prompts that you do not have permission to modify, you can run the editor as an administrator, then use the editor to open my.ini and save it.

This is the end of this article about the permanent solution to MYSQL not being able to recognize Chinese. For more related content about MYSQL not being able to recognize Chinese, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!