MySQL Fix for common UTF-8 Character Encoding Problems

utf8-fix-encoding.sql

-- based on UTF-8 Encoding Debugging Chart: http://www.i18nqa.com/debug/utf8-debug.html
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, 'Ù', 'Ù');
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, 'ÿ', 'ÿ');
-- Replace at the end!
UPDATE table SET field = replace(field, 'Â', 'Â');
UPDATE table SET field = replace(field, 'Ã', 'Ã');