Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

gistfile1.txt

locate my.cnf

change character set and collation

[mysqld]
character_set_server = utf8
collation_server = utf8_general_ci

in console if your database is not huge.

ActiveRecord::Base.connection.tables.each do |table|
ActiveRecord::Base.connection.execute "ALTER TABLE #{table} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"
end