MySQLMemo010 - やするん＠Wiki

サーバの設定を確認する

mysql> show variables like 'character_set%';

mysql> status

/etc/my.cnf 編集

[client]
default-character-set=utf8

[mysqld]
default-character-set = utf8
skip-character-set-client-handshake
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8

参考

• http://ext.omo3.com/linux/mysql_character_set.html