User:Kghbln/Error 1271: Illegal mix of collations

[mysql] default-character-set=utf8
 * Situation
 * Your MySQL server speaks UTF-8

[mysqld] collation_server=utf8_unicode_ci character_set_server=utf8
 * Your database tables speak UTF-8
 * Your columns within the tables are messed up (see Problem)


 * Problem

Replace all appearances of  with  :
 * Solution
 * 1) Dump your MySQL database
 * 2) Open your dumped MySQL database with your editor, e.g. vim
 * 3) Do the replacement with
 * 4) Save the changes to your MySQL database
 * 5) Import your MySQL database

This does not rectify already corrupted characters, i.e. there was no latin1 equivalent for the utf8 character, e.g.  displaying as   in your database.
 * Warning