title: How to export multilingual MySQL table to Excel without garbled text (e.g. à¹à¸­à¸™à¸™à)?
body: <p>I have a MySQL table where I store text entered in any kind of language. The text is displayed correctly on the website, <a href="http://scratch.mit.edu/tagged/toploved/%E0%B9%81%E0%B8%AD%E0%B8%99%E0%B8%99%E0%B8%B4%E0%B9%80%E0%B8%A1%E0%B8%8A%E0%B8%B1%E0%B9%88%E0%B8%99" rel="nofollow noreferrer">example</a> but when I export the data to Excel I get garbled text.</p>
  
  <p>I tried exporting the data via PHPMyAdmin and even just doing something from the command line like mysql -user -p db &lt; query.sql  > export.tsv  and I get  garbled text. For example instead of animación I get animaciÃ³n or instead of แอนนิเมชั่น I get à¹à¸­à¸™à¸™à¸´à¹€à¸¡à¸Šà¸±à¹ˆà¸™. </p>
  
  <p>This could be a combination of factors involving Excel, MySQL and PHPMyAdmin, but I imagine others have tried to do the same.</p>