title: How to fix mysql data encoding
body: <p>I'm working on a database that the names was saved in using <code>latin1</code> character set encoding (<code>latini_swedish_ci</code> collation) but the names were in Persian.
  <br>
  <br>
  It seems some body changed the table collation to <code>utf8</code> (<code>utf8_bin</code>) but still the data is like this :
  <br><br>
  <img src="https://i.stack.imgur.com/5Y0qD.png" alt="enter image description here" /></p>
  <p>I'm wondering how can I fix this values.
  <br><br>
  I changed table collation and <code>DB</code> collation but still I have this kind of values.
  Any help will be appreciate.
  <br>
  <br>
  <em><strong>Thank's in advance</strong></em></p>