using UTF8 in MySQL5
Monday, July 6th, 2009Problem
You want to set the default character encoding to UTF8 everywhere in your MySQL
Solution
Edit my.cnf.
On Debian or Ubuntu Linux, you can find my.cnf at /etc/mysql/my.cnf. Add those lines below.
[mysqld] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqldump] default-character-set=utf8
On MacOSX, when you installed MySQL via MacPorts, you have to create one at /opt/local/etc/mysql5/my.cnf.
[mysqld] default-character-set=utf8 socket=/opt/local/var/run/mysql5/mysqld.sock [mysql] default-character-set=utf8 [mysqldump] default-character-set=utf8 [client] socket=/opt/local/var/run/mysql5/mysqld.sock