joined:Sept 30, 2009
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?