utf8 + MySQL
If you are having problems with utf8 characters in MySQL, add this to your my.conf:
[mysqld] init_connect='SET collation_connection = utf8_general_ci' init_connect='SET NAMES utf8' default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci
Note that init_connect won’t run when the user has super privileges, so make sure you use a user without them:
REVOKE SUPER ON *.* from 'user';
if the user already has SUPER privileges.
Short URL for this post: http://tmblr.co/ZFVrZy3qhMb
