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)↓

insert image description here

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.

insert image description here

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

insert image description here

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

insert image description here

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!

You may also be interested in:

Solution to the problem that Chinese characters are converted into full question marks when inserted into Mysql???
MySQL configuration file my.cnf parameter optimization and Chinese detailed explanation
How to solve the Chinese garbled problem in Mysql (perfect solution to the garbled problem)
Chinese UTF8 garbled characters in MySQL
Several solutions to the garbled Chinese encoding of uft-8 in php and mysql
Implementation of converting Chinese characters to Pinyin in Mysql (converting each Chinese character to full Pinyin)
How to make MySQL support Chinese sorting
How to solve the problem of Chinese garbled characters when inserting table data into MySQL
Differences among MySQL character sets GBK, GB2312, and UTF8 to solve MYSQL Chinese garbled characters
Solution to MySQL Chinese garbled characters problem

<<: Semantics: Is Html/Xhtml really standards-compliant?

>>: Element UI table realizes drop-down filtering function