blog.vucica.net
Convert MySQL tables to use UTF8 character set and collation
I moved a Gerrit installation to use MySQL. The tables turned out to be using latin1 encoding. Here's a vile concoction, composed of many StackOverflow answers and swamp creatures: -- update database and each table to use utf8 according to http://stackoverflow.com/a/6115705/39974. -- to apply to each table, used http://stackoverflow.com/a/18294520/39974 -- use utf8_unicode_ci due to: http://stackoverflow.com/a/766996/39974 [...]