UTF Character encoding in MySQL
Nov 22nd 2010programming & stoopid
I’ve had on going issues with mySQL not defaulting to UTF8 and instead using Latin1 constantly. After searching around a bit on the mySQL forums, I seem to have found a series of settings that put a halt to the problem once and for all. Just add these settings to your my.cnf file:
[mysqld]
default-character-set=utf8
default-collation=utf8_bin
collation_server=utf8_bin
[mysql]
default-character-set=utf8
Cheers