Last active
August 29, 2015 14:17
-
-
Save cezarsmpio/3893aa638320df4a6065 to your computer and use it in GitHub Desktop.
Atualizar caracteres quebrados MySQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update `table` set `field` = replace(`field` ,'É','É'); | |
update `table` set `field` = replace(`field` ,'“','"'); | |
update `table` set `field` = replace(`field` ,'â€','"'); | |
update `table` set `field` = replace(`field` ,'Ç','Ç'); | |
update `table` set `field` = replace(`field` ,'Ã','Ã'); | |
update `table` set `field` = replace(`field` ,'Ã ','À'); | |
update `table` set `field` = replace(`field` ,'ú','ú'); | |
update `table` set `field` = replace(`field` ,'•','-'); | |
update `table` set `field` = replace(`field` ,'Ø','Ø'); | |
update `table` set `field` = replace(`field` ,'õ','õ'); | |
update `table` set `field` = replace(`field` ,'Ã','í'); | |
update `table` set `field` = replace(`field` ,'â','â'); | |
update `table` set `field` = replace(`field` ,'ã','ã'); | |
update `table` set `field` = replace(`field` ,'ê','ê'); | |
update `table` set `field` = replace(`field` ,'á','á'); | |
update `table` set `field` = replace(`field` ,'é','é'); | |
update `table` set `field` = replace(`field` ,'ó','ó'); | |
update `table` set `field` = replace(`field` ,'–','–'); | |
update `table` set `field` = replace(`field` ,'ç','ç'); | |
update `table` set `field` = replace(`field` ,'ª','ª'); | |
update `table` set `field` = replace(`field` ,'º','º'); | |
update `table` set `field` = replace(`field` ,'Ã ','à'); | |
update `table` set `field` = replace(`field` ,'ç','ç'); | |
update `table` set `field` = replace(`field` ,'ã','ã'); | |
update `table` set `field` = replace(`field` ,'á','á'); | |
update `table` set `field` = replace(`field` ,'â','â'); | |
update `table` set `field` = replace(`field` ,'é','é'); | |
update `table` set `field` = replace(`field` ,'í','í'); | |
update `table` set `field` = replace(`field` ,'õ','õ'); | |
update `table` set `field` = replace(`field` ,'ú','ú'); | |
update `table` set `field` = replace(`field` ,'ç','ç'); | |
update `table` set `field` = replace(`field` ,'Á','Á'); | |
update `table` set `field` = replace(`field` ,'Â','Â'); | |
update `table` set `field` = replace(`field` ,'É','É'); | |
update `table` set `field` = replace(`field` ,'Í','Í'); | |
update `table` set `field` = replace(`field` ,'Õ','Õ'); | |
update `table` set `field` = replace(`field` ,'Ú','Ú'); | |
update `table` set `field` = replace(`field` ,'Ç','Ç'); | |
update `table` set `field` = replace(`field` ,'Ã','Ã'); | |
update `table` set `field` = replace(`field` ,'À','À'); | |
update `table` set `field` = replace(`field` ,'Ê','Ê'); | |
update `table` set `field` = replace(`field` ,'Ó','Ó'); | |
update `table` set `field` = replace(`field` ,'Ô','Ô'); | |
update `table` set `field` = replace(`field` ,'Ü','Ü'); | |
update `table` set `field` = replace(`field` ,'ã','ã'); | |
update `table` set `field` = replace(`field` ,'à','à'); | |
update `table` set `field` = replace(`field` ,'ê','ê'); | |
update `table` set `field` = replace(`field` ,'ó','ó'); | |
update `table` set `field` = replace(`field` ,'ô','ô'); | |
update `table` set `field` = replace(`field` ,'ü','ü'); | |
update `table` set `field` = replace(`field` ,'&','&'); | |
update `table` set `field` = replace(`field` ,'>','>'); | |
update `table` set `field` = replace(`field` ,'<','<'); | |
update `table` set `field` = replace(`field` ,'ˆ','ˆ'); | |
update `table` set `field` = replace(`field` ,'˜','˜'); | |
update `table` set `field` = replace(`field` ,'¨','¨'); | |
update `table` set `field` = replace(`field` ,'&cute;','´'); | |
update `table` set `field` = replace(`field` ,'¸','¸'); | |
update `table` set `field` = replace(`field` ,'"','"'); | |
update `table` set `field` = replace(`field` ,'“','“'); | |
update `table` set `field` = replace(`field` ,'”','”'); | |
update `table` set `field` = replace(`field` ,'‘','‘'); | |
update `table` set `field` = replace(`field` ,'’','’'); | |
update `table` set `field` = replace(`field` ,'‹','‹'); | |
update `table` set `field` = replace(`field` ,'›','›'); | |
update `table` set `field` = replace(`field` ,'«','«'); | |
update `table` set `field` = replace(`field` ,'»','»'); | |
update `table` set `field` = replace(`field` ,'º','º'); | |
update `table` set `field` = replace(`field` ,'ª','ª'); | |
update `table` set `field` = replace(`field` ,'–','–'); | |
update `table` set `field` = replace(`field` ,'—','—'); | |
update `table` set `field` = replace(`field` ,'¯','¯'); | |
update `table` set `field` = replace(`field` ,'…','…'); | |
update `table` set `field` = replace(`field` ,'¦','¦'); | |
update `table` set `field` = replace(`field` ,'•','•'); | |
update `table` set `field` = replace(`field` ,'¶','¶'); | |
update `table` set `field` = replace(`field` ,'§','§'); | |
update `table` set `field` = replace(`field` ,'¹','¹'); | |
update `table` set `field` = replace(`field` ,'²','²'); | |
update `table` set `field` = replace(`field` ,'³','³'); | |
update `table` set `field` = replace(`field` ,'½','½'); | |
update `table` set `field` = replace(`field` ,'¼','¼'); | |
update `table` set `field` = replace(`field` ,'¾','¾'); | |
update `table` set `field` = replace(`field` ,'⅛','⅛'); | |
update `table` set `field` = replace(`field` ,'⅜','⅜'); | |
update `table` set `field` = replace(`field` ,'⅝','⅝'); | |
update `table` set `field` = replace(`field` ,'⅞','⅞'); | |
update `table` set `field` = replace(`field` ,'>','>'); | |
update `table` set `field` = replace(`field` ,'<','<'); | |
update `table` set `field` = replace(`field` ,'±','±'); | |
update `table` set `field` = replace(`field` ,'−','−'); | |
update `table` set `field` = replace(`field` ,'×','×'); | |
update `table` set `field` = replace(`field` ,'÷','÷'); | |
update `table` set `field` = replace(`field` ,'∗','∗'); | |
update `table` set `field` = replace(`field` ,'⁄','⁄'); | |
update `table` set `field` = replace(`field` ,'‰','‰'); | |
update `table` set `field` = replace(`field` ,'∫','∫'); | |
update `table` set `field` = replace(`field` ,'∑','∑'); | |
update `table` set `field` = replace(`field` ,'∏','∏'); | |
update `table` set `field` = replace(`field` ,'√','√'); | |
update `table` set `field` = replace(`field` ,'∞','∞'); | |
update `table` set `field` = replace(`field` ,'≈','≈'); | |
update `table` set `field` = replace(`field` ,'≅','≅'); | |
update `table` set `field` = replace(`field` ,'∝','∝'); | |
update `table` set `field` = replace(`field` ,'≡','≡'); | |
update `table` set `field` = replace(`field` ,'≠','≠'); | |
update `table` set `field` = replace(`field` ,'≤','≤'); | |
update `table` set `field` = replace(`field` ,'≥','≥'); | |
update `table` set `field` = replace(`field` ,'∴','∴'); | |
update `table` set `field` = replace(`field` ,'⋅','⋅'); | |
update `table` set `field` = replace(`field` ,'·','·'); | |
update `table` set `field` = replace(`field` ,'∂','∂'); | |
update `table` set `field` = replace(`field` ,'ℑ','ℑ'); | |
update `table` set `field` = replace(`field` ,'ℜ','ℜ'); | |
update `table` set `field` = replace(`field` ,'′','′'); | |
update `table` set `field` = replace(`field` ,'″','″'); | |
update `table` set `field` = replace(`field` ,'°','°'); | |
update `table` set `field` = replace(`field` ,'∠','∠'); | |
update `table` set `field` = replace(`field` ,'⊥','⊥'); | |
update `table` set `field` = replace(`field` ,'∇','∇'); | |
update `table` set `field` = replace(`field` ,'⊕','⊕'); | |
update `table` set `field` = replace(`field` ,'⊗','⊗'); | |
update `table` set `field` = replace(`field` ,'ℵ','ℵ'); | |
update `table` set `field` = replace(`field` ,'ø','ø'); | |
update `table` set `field` = replace(`field` ,'Ø','Ø'); | |
update `table` set `field` = replace(`field` ,'∈','∈'); | |
update `table` set `field` = replace(`field` ,'∉','∉'); | |
update `table` set `field` = replace(`field` ,'∩','∩'); | |
update `table` set `field` = replace(`field` ,'∪','∪'); | |
update `table` set `field` = replace(`field` ,'⊂','⊂'); | |
update `table` set `field` = replace(`field` ,'⊃','⊃'); | |
update `table` set `field` = replace(`field` ,'⊆','⊆'); | |
update `table` set `field` = replace(`field` ,'⊇','⊇'); | |
update `table` set `field` = replace(`field` ,'∃','∃'); | |
update `table` set `field` = replace(`field` ,'∀','∀'); | |
update `table` set `field` = replace(`field` ,'∅','∅'); | |
update `table` set `field` = replace(`field` ,'¬','¬'); | |
update `table` set `field` = replace(`field` ,'∧','∧'); | |
update `table` set `field` = replace(`field` ,'∨','∨'); | |
update `table` set `field` = replace(`field` ,'↵','↵'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment