title: UTF8 to latin1_swedish_ci
body: <p>There are a lot of topics about latin1_swedisch_ci to utf8 conversion. But what about the other way around? I'm dealing for quite a long time with this problem and I haven't found a solution so far. Since I don't know what else is accessing this database, I don't want to change the character encoding of the table.</p>
  
  <p>I have in the table a column which is formatted in latin1_swedisch_ci. Now I have to write queries in php. This database contains German and French names, meaning that I have characters like ö,ä,ô and so on. How can I do that? </p>
  
  <p>As an example if I want to query the name 'Bürki', then I have to write something like $name='BÃ¼rki'. Is there a proper way to convert it to latin1_swedisch_ci without using string replacement for those special characters?</p>