[Original] how to set the default character set encoding of MySQL database to GBK

I have been engaged in the discuz Forum recently, using MySQL + PHP

Because the default character set encoding of MySQL is Latin, we generally use GBK or gb2312 encoding.
So it is easy to cause garbled characters if it is not changed.

I am using MySQL 5.0 for installation.ProgramInstallation Directory: C: \ Program Files \ mysql \ MySQL Server 5.0
Go to this directory and find my. INI File

Modify default-character-set = Latin1 to default-character-set = GBK

Remember, there are two things to change.

The most important thing is to stop the MySQL service before modifying the file, and restart it after modification.
Use the doscommand: net stop MySQL to stop the service. Net start MySQL to start

Then, execute your MySQL script. Everything is OK! Here you can use discuz SQL as an example to run it!