How to change the default MySql sort for rake db: create: all in rails?

Question

In my rails application, I run rake db: create: all to create the databases, and they tell me that the mappings do not match. Is there a way to change the default MySQL setting? If this is not the best way? Thanks

Answer 1

Mapping parameters are specified in the MySQL configuration file (usually called my.cnf). It should look something like this (in the section [mysqld]):

character-set-server=utf8
collation-server=utf8_general_ci

Additional Information:

• http://dev.mysql.com/doc/refman/5.0/en/charset-server.html
• http://macboypro.com/blog/2009/07/31/mysql-5-1-riding-on-utf8-collation-client-and-server-tutorial/
• http://mysql2.mirrors-r-us.net/doc/refman/5.1/en/charset-connection.html