| Search and replace characters in a MySQL table
|
ocon
msg:4465711 | 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?
|
coopster
msg:4472744 | 12:20 pm on Jul 5, 2012 (gmt 0) |
If your rows have last update timestamps you could narrow down which rows have not been updated yet since the initial import and you could update just those rows.
|
|
|
