Skip to content

Instantly share code, notes, and snippets.

@TimLang

TimLang/gist:ffc7c03cf277fd83526194b831289fd1

Forked from sukeerthiadiga/gist:3772311
Created July 21, 2020 02:01
Show Gist options
  • Save TimLang/ffc7c03cf277fd83526194b831289fd1 to your computer and use it in GitHub Desktop.
Save TimLang/ffc7c03cf277fd83526194b831289fd1 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment