How to fix double-encoded UTF8 characters (in an utf-8 table)

by

The following MySQL function will return the correct utf8 string after double-encoding:

CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8)

It can be used with an UPDATE statement to correct the fields:

UPDATE tablename SET
    field = CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8);

More Related Contents:

  1. Trouble with UTF-8 characters; what I see is not what I stored
  2. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  3. How to detect UTF-8 characters in a Latin1 encoded column – MySQL
  4. Fetching UTF-8 text from MySQL in R returns “????”
  5. How to convert an entire MySQL database characterset and collation to UTF-8?
  6. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  7. Change MySQL default character set to UTF-8 in my.cnf?
  8. How to convert a string to date in MySQL?
  9. How to make MySQL handle UTF-8 properly
  10. How to conduct an Accent Sensitive search in MySql
  11. How to find similar results and sort by similarity?
  12. How can I find non-ASCII characters in MySQL?
  13. UTF-8: General? Bin? Unicode?
  14. Save Data in Arabic in MySQL database
  15. How do you extract a numerical value from a string in a MySQL query?
  16. SQL order string as number
  17. How to escape single quotes in MySQL
  18. Differences between utf8 and latin1
  19. What are the differences between utf8_general_ci and utf8_unicode_ci? [duplicate]
  20. Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
  21. Can MySQL replace multiple characters?
  22. Loading utf-8 encoded text into MySQL table
  23. mysql: why comparing a ‘string’ to 0 gives true?
  24. MySQL : how to remove double or more spaces from a string?
  25. Strip last two characters of a column in MySQL
  26. MySql Query Replace NULL with Empty String in Select
  27. Detecting utf8 broken characters in MySQL
  28. MySQL throws Incorrect string value error
  29. UTF-8 not working in HTML forms
  30. Mysql server does not support 4-byte encoded utf8 characters

Leave a Comment