How to convert your latin1 mysql table to utf8

Convert the existing columns content if there are unicode characters saved in non utf8 column: Have MYSQL loop through . all of your tables and columns finding all the necessary columns which have types needing to be converted: You will get queries like these which can be ran: Then we update the each tables overarching … Continued

Add Special Chars to WordPress TinyMCE Char Map

Had an issue where a clients blog post had one of theseĀ in the post and it wasn’t being displayed right. The real issue was changingĀ the ‘post_content’ field of the wp_posts table to UTF-8 Unicode (utf8mb4) from cp1252 West European, but (!) along the way I tried this. Put this in a plugin or functions.php and … Continued