title: Converting latin1_swedish_ci to utf8 with PHP
body: <p>I have a database filled with values like <code>â™¥â€¢â—â™¥ Dhaka â™¥â€¢â—â™¥</code> (Which should be <code>♥•●♥ Dhaka ♥•●♥</code>) as I didnt specify the collation while creating the database.<br>
  Now I want to Fix it. I cannot fetch the data again from where I got it from at the first place. So I was thinking if it might be possible to fetch the data in a php script and convert it to the correct characters.<br>
  I've changed the collation of the database and the fields to <code>utf8_general_ci</code>.. </p>