Solve the Problem of garbled characters when importing GBK database files to the MySQL database through source.

Importing gbk to a database is a headache, especially when some software providers do not provide the import/export function and encounter large. SQL files. Numerous explorations

Importing gbk to a database is a headache, especially when some software providers do not provide the import/export function and encounter large. SQL files. Numerous explorations

Importing gbk to a database is a headache, especially when some software providers do not provide the import/export function and encounter large. SQL files. After numerous explorations, I finally found a solution.

1. First set the database format to gbk

Alter database databasename character set gbk;

Set the client to gbk.

Set names gbk;

Then import the data through source:

Source filename. SQL

OK. Import successful