Navicat connection MySQL Database Chinese display garbled solution

Refer to the following workaround

Click on a connection--properties--Switch to the Advanced tab--Remove the "use MySQL character set" option – Select 65001 (UTF-8) or 10008-gb2312 in the "Code" section, and then turn it on to display the Chinese language normally.

If the above method can not resolve the reference

The default encoding for the My.ini file in the MySQL installation directory is problematic, and the default encoding of these two my.ini files

code is as follows

copy code

========================================== [MySQL] Default-character-set=utf8 <------ ========================================== [mysqld] # The TCP/IP Port the MySQL Server would listen on port=3306 #Path to installation directory. All paths are usually resolved relative to this. basedir= "C:/Program files/mysql/mysql Server 5.0/" #Path to the database root datadir= C:/Program files/mysq L/mysql Server 5.0/data/' # The default character set that'll be used when a new schema or table is # created D No character set is defined Default-character-set=utf8 <------

The

===========================================
Arrow refers to the place that is guaranteed to be UTF8 (note not utf-8), Navicat In the use of the MySQL character set (this time no longer choose Utf-8 encoding), the problem can be solved