mysql, 캐릭터셋 변경

$ vi /etc/mysql/my.cnf
---
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
---
[client]
default-character-set = utf8

[mysqld]
character-set-client-handshake=FALSE
init_connect="SET collation_connection = utf8_general_ci"
init_connect="SET NAMES utf8"
character-set-server = utf8
collation-server = utf8_general_ci

[mysqldump]
default-character-set = utf8

[mysql]
default-character-set = utf8
---

mysql> alter database DBNME default character set utf8;
mysql> show variables like 'c%'
mysql> status

$ service mysql restart

mysql> alter table data_code change column description description varchar(50) character set 'utf8' null default null;