MySQL Query condition Chinese problem

This is a problem with MySQL character encoding because the MySQL default character encoding is Latin1
It does not recognize Chinese, so garbled text will appear when reading query statements
So that the query condition is incorrect
So we just need to change its character encoding to
It's usually used UTF8.


Change the MySQL configuration file here so that its default character encoding is UTF8


Found in/mysql/my.ini [client]
Add Default-character-set=utf8
Find [MySQL]


Add Default-character-set=utf8

There is another way. NET link string Nega Charset=utf8;

MySQL Query condition Chinese problem