60designwebpick mysq GBKL garbled

I now have a SQL file with the contents of GBK. I now show all is garbled.
Just use MySQL 4.0.26 to display.
With more than 4.1 of the dead and alive are not shown. The head is big. I hope you have pointed out, Thanksgiving is endless.
I now have MySQL 5.0.22.
I changed the character set in My.ini to GBK, and it was GBK with the status command. Then I import the SQL file with the source command, but not yet. I used the set names Gbk,set names Utf8,set names latin1 before querying. Everything is garbled.
With Mysql-uroot-ppassword database The SQL file header is like this.
--MySQL Dump 10.10
--
--Host:localhost Database:system
-- ------------------------------------------------------
--Server version 5.0.22-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS =@ @CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATI/;
/*!40101 SET NAMES UTF8 */;
/*!40103 SET @OLD_TIME_Z/;
/*!40103 SET time_z/;
/*!40014 SET @OLD_UNIQUE_CHECKS =@ @UNIQUE_CHECKS, unique_checks=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS =@ @FOREIGN_KEY_CHECKS, foreign_key_checks=0 */;
/*!40101 SET @OLD_SQL_MODE =@ @SQL_MODE, sql_mode= ' no_auto_value_on_zero ' */;
/*
No words anymore. I hope you are pointing out. Thank you.

Copy the Code code as follows:

The Perfect solution:
1. No matter what method you use, export the SQL text file to make sure that EditPlus opens to see Chinese.
2. Change the SQL file's statement to 4.1, delete the encoded statement, and save it.
3. Use the command line to import 4.1 database, remember, this database encoding to be set to GBK, when the table is built, it is automatically designated as GBK
Attached command:
mysql-hlocalhost-uroot-p**** Database--DEFAULT-CHARACTER-SET=GBK < Database.sql
After the export, also remember--DEFAULT-CHARACTER-SET=GBK
Write the program, MySQL before the inquiry, be sure to set names!
The above is my experience of countless failures and tests accumulated over a long period of time.

The above describes the 60designwebpick mysq GBKL garbled, including 60designwebpick aspects of the content, I hope that the PHP tutorial interested friends helpful.

