MySqlの文字コードをUTF-8に
いつも忘れてしまうのでメモ。
/etc/my.cnfに
[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
default-character-set = utf8
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8
[client]
default-character-set=utf8
/etc/my.cnfに
[mysqld]
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
default-character-set = utf8
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8
[client]
default-character-set=utf8