Convert MySQL tables and data from latin1 to utf8

Submitted by Kamal Wickramanayake on September 12, 2009 - 17:14

Context: MySQL tables maintain textual data in latin1 character encoding unless the default settings are overridden at the server, database, table or column level. Still it is possible that text in utf8 goes into these latin1 tables (for example via a web form submission). For some reason you want to change the character set from latin1 to utf8.