Convert latin1 characters on a UTF8 table into UTF8

by

From what you describe, it seems you have UTF-8 data that was originally stored as Latin-1 and then not converted correctly to UTF-8. The data is recoverable; you’ll need a MySQL function like 

convert(cast(convert(name using  latin1) as binary) using utf8)

It’s possible that you may need to omit the inner conversion, depending on how the data was altered during the encoding conversion.

More Related Contents:

  1. UTF-8 not working in HTML forms
  2. UTF-8 all the way through
  3. How do I remove  from the beginning of a file?
  4. PHP DOMDocument loadHTML not encoding UTF-8 correctly
  5. SET NAMES utf8 in MySQL?
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. PHP: Convert any string to UTF-8 without knowing the original character set, or at least try
  8. Detect encoding and make everything UTF-8
  9. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  10. Fixing broken UTF-8 encoding
  11. UTF-8 BOM signature in PHP files
  12. Convert utf8-characters to iso-88591 and back in PHP
  13. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  14. Getting ’ instead of an apostrophe(‘) in PHP
  15. PDO + MySQL and broken UTF-8 encoding
  16. Can’t insert Chinese character into MySQL
  17. MySQL diacritic insensitive search (spanish accents)
  18. dompdf character encoding UTF-8
  19. Is “SET CHARACTER SET utf8” necessary?
  20. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  21. Detect file encoding in PHP
  22. UTF-8 safe equivalent of ord or charCodeAt() in PHP
  23. PHP messing with HTML Charset Encoding
  24. UTF-8 character encoding battles json_encode() [duplicate]
  25. Replacing invalid UTF-8 characters by question marks, mbstring.substitute_character seems ignored
  26. Save Accents in MySQL Database
  27. The ultimate emoji encoding scheme
  28. Is a BLOB converted using the current/default charset in MySQL?
  29. Decoding numeric html entities via PHP
  30. Join two tables with comma separated values

Leave a Comment