December 2008
2 posts
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...