ocon - 4:06 am on Jun 15, 2012 (gmt 0)

I discovered I incorrectly imported data into my database as some accented characters are corrupted.

For example, instead of "Tucumán" I get "Tucumán".

I've made changes to this data so I don't want to dump it and reimport it but try to salvage it if I can.

I noticed each character corrupts the same way:

á=>á
ç=>ç
ã=>ã
º=>º

Is there a command I can use to search and replace strings in the table across all the columns? Or maybe some even better fix?