title: MySQL UTF8 Database migration
body: <p>I'm having problems to migrate an utf8 database to another server... Each source and destination table has a <code>"DEFAULT CHARSET=utf8"</code>.</p>
  
  <p>I use mysqldump to dump data and <code>mysql &lt; file.sql</code> to import but when in the source table i have "España", in the destination i get "EspaÃ±a".</p>
  
  <p>I read some guides, i used <code>--default-character-set=latin1</code> to export and import, but the problem remains. 
  I also tried a <code>--default-character-set=utf8</code> to import, but the result is: "Espa", data is truncated to the first occurrence of a multibyte char.</p>
  
  <p>I need help!</p>
  
  <p>Thank you in advance</p>