title: Exporting Chinese characters from MySQL
body: <p>I have a problem with Chinese characters while exporting query results to an XLS file. In my database Chinese character are stored like as encoded format like this</p>
  
  <pre><code>Ã¦â€“Â°Ã©â€¡Å’Ã§Â¨â€¹Ã©â€ºâ€ Ã¥â€ºÂ¢
  </code></pre>
  
  <p>When I show these character on a webpage they are automatically converted in standard Chinese characters with the help of a header function provided by PHP. But we want to extract Chinese characters for an XLS file from MySQL with standard Chinese character.</p>