Gbk-encoded data is imported to the utf8-encoded database.

The encoding is utf8. To import gbk or other encoded data, right-click the navicat database and choose run SQL file. Select the encoding format and import it.

If navicat is not installed, use the following methods:

1. Use a text tool to open the SQL file, find the SQL statement for creating the table, and manually replace gbk encoding with utf8

2. Use SQL syntax. If there are few fields, use the CONVERT (XXX USING GBK) function)

3. You can also set utf8 encoding when exporting the gbk database, and then import it to the utf8 database.

Link: http://www.dayecn.com/tanteng/article/gbk-utf8-import/