LifeinAsia - 6:33 pm on Nov 6, 2012 (gmt 0)

I have some content that users have entered through different forms. It's multilingual and sometimes there's been a mismatch with character formatting.

In one example, the Koreanization of "Allstate" was entered as "올스테이트" instead of in euc-kr formatting (which the rest of the site uses).

Although in the end it seems to display okay in browsers, I need to make it searchable within the DB.

How can I convert strings like this into euc-kr (or ideally, UTF-8)?