php & mysql converting non- to unicode <p>I have characters like these on our web site: FÃƒÂ©mnyomÃƒÂ³</p> <p>That is a street address, entered in another language (though I do not know which). Here's the db setup:</p> <pre><code>mysql 4.1.2log charset cp1252 West European (latin1) </code></pre> <p>I'm using PHP but without mbstrings() (though I do no string conversions on this address, just echo).</p> <p>If I changed the mysql charset from cp1252 to UTF-8 and made sure I used things like <code>header( 'Content-Type: text/html; charset=UTF-8' );</code> would that improve my situation? Or, is the data hosed because it was saved in the cp1252 charset and there is nothing I can do? The original database was created in 2002 and has been used/expanded since. We've upgraded servers and re-imported dumps but ashamedly I admit to not giving charsets much thought.</p> <p>If I'm hosed, I'll probably just remove the text in those fields but I'd like to support unicode going forward, so if I issue <code>ALTER database_name DEFAULT CHARACTER SET utf8;</code> will that make sure future multibyte encodings are saved correctly, taking at least storage out of the equation (leaving me to worry about PHP)?</p> <p>Thanks -</p>