Reference for converting UTF8 in a MySql DB

Wonder if anyone can help.

I recently had an issue with UTF8 in the Database and pages of a bespoke CMS I inherited. Going forward that's all sorted now, the code and DB has been changed to cater and properly convert, however I have an issue in that existing entries in the DB are obvioulsy sat there in the old character format and I need to convert all those.

Eg Ķ, ī

I was going to run an replace in the mysql DB to replace all these, but what I could do with is knowing what all these weird characters translate to eg ó.

Can anyone recommend a good table/reference to look at 开发者_JAVA技巧? I have been searching but can't seem to come up with the right thing.

If I understand right these are two byte UTF8 characters.

Thanks

Try running these values in utf8_decode.

It looks like they've been valid, then utf8_encode'd.

If that's the case, try running a loop and update these rows.