Default charset = utf8 and collation = utf8_general_ci when create new mysql db

[saosangmo]

Hi,
When my users create new mysql db, their collation of db is latin1_swedish_ci. Now, I want to change the default collation to utf8_general_ci.
Could you help me?
many thanks

-saosangmo

 

[zEitEr]

Hello,

You need to update /etc/my.cnf to fit your needs, and add

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

More details:
http://dev.mysql.com/doc/refman/5.0/en/charset-applications.html