Ways to modify the MySQL default encoding

The simplest and most thorough method under Windows systems:
1, stop the MySQL service
2, in the MySQL installation directory to find My.ini, if not the My-medium.ini copy as a my.ini can
3, after opening the My.ini, in [client] and [mysqld] below all add Default-character-set=utf8, save and close
4. Start MySQL Service

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

three. Configure sorting character Set

Myisamchk-r-Q--set-character-set=charset