How to modify MySQL's character set

Modifying the default character set for MySQL is done by modifying its configuration file. Generally, there are two kinds of situations:

Windows platform

The MySQL configuration file under Windows is My.ini, generally in C:\windows\my.ini or c:\winnt\my.ini can be directly added to this file

DEFAULT-CHARACTER-SET=GBK #或gb2312, Big5,utf8

Then restart MySQL

Service MySQL Restart

Or

/etc/init.d/mysql restart

Or another way to reboot, it will take effect.

UNIX Platform

Linux under the MySQL configuration file is my.cnf, is generally/etc/my.cnf, if you can not find the command to find the following:

Find/-iname MY.CNF

In this file, add

DEFAULT-CHARACTER-SET=GBK #或gb2312, Big5,utf8

Then restart MySQL

net stop MySQL

net start MySQL

is in effect.