Use MySQL to link to myeclipse with garbled characters

If you use MySQL to link to myeclipse, you will encounter garbled code. I think this is also a problem that many people have encountered. Next I will explain how to solve these garbled code problems,

First, MySQL can be properly displayed, but it is linked to myeclipse to establish a dbbrowser, right-click connected to MySQL, and click New SQL editor to view the contents in the table, garbled characters, this may be caused by the MySQL encoding configuration. Make the following changes and find the MySQL configuration folder my. ini.

[Client]

Port = 3306

[MySQL]

Default-character-set = GBK // This is the place to change. Someone may be Latin1

# Server section
#----------------------------------------------------------------------
#
# The following options will be read by the MySQL server. Make sure that
# You have installed the server correctly (see above) So it reads this
# File.
#
[Mysqld]

# The TCP/IP Port the MySQL server will listen on
Port = 3306

# Path to installation directory. All paths are usually resolved relative to this.
Basedir = "E:/MySQL sever /"

# Path to the Database Root
Datadir = "E:/MySQL sever/data /"

# The default character set that will be used when a new schema or table is
# Created and no character set is defined
Default-character-set = utf8 // This is the MySQL local character access. Someone needs to change it to Latin1.

 

After modification, go to the control panel service to first turn off the MySQL service and then restart (this is very important), and then delete the original encoded table, so as to create a new table, there will be no garbled characters in myeclipse