Fixing broken UTF-8 encoding

by

If you have double-encoded UTF8 characters (various smart quotes, dashes, apostrophe ’, quotation mark “, etc), in mysql you can dump the data, then read it back in to fix the broken encoding.

Like this:

mysqldump -h DB_HOST -u DB_USER -p DB_PASSWORD --opt --quote-names \
    --skip-set-charset --default-character-set=latin1 DB_NAME > DB_NAME-dump.sql

mysql -h DB_HOST -u DB_USER -p DB_PASSWORD \
    --default-character-set=utf8 DB_NAME < DB_NAME-dump.sql

This was a 100% fix for my double encoded UTF-8.

Source:
http://blog.hno3.org/2010/04/22/fixing-double-encoded-utf-8-data-in-mysql/

More Related Contents:

  1. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  2. UTF-8 all the way through
  3. How to decode Unicode escape sequences like “\u00ed” to proper UTF-8 encoded characters?
  4. Reference: Why are my “special” Unicode characters encoded weird using json_encode?
  5. SET NAMES utf8 in MySQL?
  6. MySQL and PHP: UTF-8 with Cyrillic characters [duplicate]
  7. preg_match and UTF-8 in PHP
  8. Convert latin1 characters on a UTF8 table into UTF8
  9. PHP: Convert unicode codepoint to UTF-8
  10. UTF-8 to Unicode Code Points
  11. How to store the data in unicode in hindi language
  12. can I get the unicode value of a character or vise versa with php?
  13. Trim unicode whitespace in PHP 5.2
  14. How to display Unicode data with PHP [duplicate]
  15. strlen() and UTF-8 encoding
  16. Is “SET CHARACTER SET utf8” necessary?
  17. UTF-8 not working in HTML forms
  18. The ultimate emoji encoding scheme
  19. Is a BLOB converted using the current/default charset in MySQL?
  20. UTF8 Filenames in PHP and Different Unicode Encodings
  21. Trim unicode whitespace in PHP
  22. Comma separated numeric values – PHP CodeIgniter
  23. How to remove all non printable characters in a string?
  24. implement LIKE query in PDO
  25. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  26. How I can create installer for website. PHP mysql [closed]
  27. How to join two tables with ssp.class.php
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Auto Increment skipping numbers?
  30. Decoding numeric html entities via PHP

Leave a Comment