title: MySQL Convert latin1 data to UTF8
body: <p>I imported some data using LOAD DATA INFILE into a MySQL Database.  The table itself and the columns are using the UTF8 character set, but the default character set of the database is latin 1.  Because the default character type of the database is latin1, and I used LOAD DATA INFILE without specifying a character set, it interpreted the file as latin1, even though the data in the file was UTF8.  Now I have a bunch of badly encoded data in my UTF8 colum.  I found <a href="http://www.mysqlperformanceblog.com/2007/12/18/fixing-column-encoding-mess-in-mysql/" rel="noreferrer">this article</a> which seems to address a similar problem, which is "UTF8 inserted in cp1251", but my problem is "Latin1 inserted in UTF8".  I've tried editing the queries there to convert the latin1 data to UTF8, but can't get it to work.  Either the data comes out the same, or even more mangled than before.  Just as an example, the word Québec is showing as QuÃ©bec.</p>
  
  <p>[ADDITIONAL INFO]</p>
  
  <p>When Selecting the data wrapped in HEX(), QuÃ©bec has the value 5175C383C2A9626563.</p>
  
  <p>The Create Table (shortened) of this table is.</p>
  
  <pre><code>CREATE TABLE MyDBName.`MyTableName`
  (
  `ID` INT NOT NULL AUTO_INCREMENT, 
  .......
  `City` CHAR(32) NULL, 
  .......
  `)) ENGINE InnoDB CHARACTER SET utf8;
  </code></pre>