The SQL exported from the MySQL database is garbled.

MySQL Database Export SQL garbled solution environment: NavicatforMysql8.2 + MySQL Sever 5.1 problem: MySQL Database Export SQL garbled solution: Method 1: The database encoding into UTF-8. Database --------> right-click --------> database properties --------> Character Set --------> select UTF-8 --------> OK. Www.2cto.com method 2 (if garbled characters still exist after method 1): Use the command to export the database. Win + R --------> cmd --------> switch to the bin directory of Mysql (or add the bin directory of mysql in the system environment variable) --------> enter the following command --------> and then enter the password. [SQL] mysqldump-u root-p zxct> c: \ users \ wentasy \ desktop \ zxct. SQL www.2cto.com Note: root: User Name zxct: Database Name zxct. SQL: export the database SQL file name. If no directory is specified, it is saved in the bin directory of mysql.

References: http://www.bkjia.com/database/201207/139330.htmlhttp://www.bkjia.com/database/201207/139338.html author Wentasy