title: export accents wrong phpmyadmin
body: <p>I have a big problem into my server.<br>
  I have to export a database, but when I try and import it accent are wrong.<br>
  For example I hava table with collation latin1_swedish_ci and a row into the old database like this:</p>
  
  <pre><code>Das Nationale Transplantation âCentrum 
  </code></pre>
  
  <p>I export the table from my phpmyadmin because I don't have access to the ssh of this server.
  The export is .sql with compatibility mode:NONE</p>
  
  <p>I create the table into new server in latin1_swedish_ci and try to import the sql the record now is this:</p>
  
  <pre><code>Das Nationale Transplantation â??Centrum
  </code></pre>
  
  <p>How can I export my table without lost this accent?</p>