View and set the MySQL character set

Http://218.194.248.2/~wuxiaogang/cpcourse/database/mysql/charset.htm

1. Modify the MySQL my.cnf
# VI/ETC/MY.CNF

Add under [client]
Default-character-set=utf8

Add under [mysqld]
Default-character-set=utf8

If there is no my.cnf, find the location of the CNF for MySQL
# Find/-iname ' *.cnf '-print

Locate and then copy my-small.cnf, my-medium.cnf any one of the/ETC/MY.CNF
# CP/USR/SHARE/MYSQL/MY-MEDIUM.CNF/ETC/MY.CNF


2. Restart MySQL
#/etc/rc.d/init.d/mysql Restart
Or
# Service Mysqld Restart


3. View the character set
Mysql> Show variables like ' collation% ';
Mysql> Show variables like ' character% ';

View and set the MySQL character set