help adding foreign chars to mysql

[Anon]

I need to add foreign city names into my mysql database. And they load fine, but I cant manipulate that after they are loaded. (such as upper case all or lower case all) Im thinking I need to load them as Dec or hex form, does anyone have any suggestions?

Thanks!