set_mysql_charset_to_utf8.rb

# 把部分latin1编码的mysql表转化为UTF8编码

ActiveRecord::Base.connection.tables.select do |t|
  ActiveRecord::Base.connection.execute("show create table #{t}").to_a[0][1].match(/CHARSET=latin1/)
end.each do |t|
  ActiveRecord::Base.connection.execute("alter table #{t} CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;")
end