I fixed with
UPDATE wp_zcs9ck_posts_copy SET post_title =
CONVERT(BINARY CONVERT(post_title USING latin1) USING utf8);
Complete solution: http://jonisalonen.com/2012/fixing-doubly-utf-8-encoded-text-in-mysql/
More Related Contents:
- Trouble with UTF-8 characters; what I see is not what I stored
- What’s the difference between utf8_general_ci and utf8_unicode_ci?
- How to make MySQL handle UTF-8 properly
- “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- How to conduct an Accent Sensitive search in MySql
- How to display UTF-8 characters in phpMyAdmin?
- UTF-8: General? Bin? Unicode?
- How to remove accents in MySQL?
- Differences between utf8 and latin1
- Incorrect string value: ‘\xF0\x9F\x8E\xB6\xF0\x9F…’ MySQL
- MySQL VARCHAR Lengths and UTF-8
- How to detect UTF-8 characters in a Latin1 encoded column – MySQL
- Fetching UTF-8 text from MySQL in R returns “????”
- How to fix double-encoded UTF8 characters (in an utf-8 table)
- Loading utf-8 encoded text into MySQL table
- MySQL command line formatting with UTF8
- SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
- MySQL throws Incorrect string value error
- Mysql server does not support 4-byte encoded utf8 characters
- UTF8 problem with MySQL 5
- Delete all Duplicate Rows except for One in MySQL? [duplicate]
- MySQL string replace
- Mysql Convert Column to row (Pivot table )
- Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
- Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
- Greatest value of multiple columns with column name?
- insert data from one table to another in mysql
- Which ORM should I use for Node.js and MySQL? [closed]
- MySQL select all rows from last month until (now() – 1 month), for comparative purposes