Troubleshooting of MYSQL Chinese garbled characters in XAMPP

Description of troubleshooting of Chinese garbled MYSQL in XAMPP: After XAMMP is installed, the MySQL database is built in. Create your own database-create a database table-add Chinese records to the table through jdbc-all the Chinese characters stored in the table are garbled. Www.2cto.com: 1. Locate D: \ xampp \ mysql \ bin \ my in the installation directory. ini, open: 2. Find the mark [mysqld] And MARK [mysql] 3. Add the encoding configuration information under the mark: the default-character-set = gbk is modified as follows: ini code [mysql] no-auto-rehash default-character-set = gbk www.2cto.com Ini code [mysqld] port = 3306 character-set-server = gbk 4. After modification, restart the mysql database. 5. Delete the old database and create a new database. The new database supports Chinese characters. Author: huangqiqing123