Locate or write a script that upgrades all text fields to UTF8. I couldn't find a suitable script. Be aware that CHAR types might be silently truncated if the UTF8 representation is longer, so you might want to also map CHAR to VARCHAR or enable strict mode.