CODEWITHSUNDEEP
phpmysqlwordpresscharacter-encoding
Felipe
Felipe

Reputation: 35

Is there a way to fix an encoding issue directly in my Mysql?

I'm having an issue with my Wordpress install. Somehow all the content was inserted in the database with a wrong charset, but in the frontend is working smoothly.

As you can see here: http://prntscr.com/8vifc3

I'm changing my host, but when I imported my site won'r render the encoding properly because of the way that the content was inserted.

There's a way so I can fix the encoding directly in my previous mysql before I export it?

Thanks

Upvotes: 1

Views: 45

Answers (3)

Rick James
Rick James

Reputation: 142208

That's Mojibake

  • The bytes you have in the client are correctly encoded in utf8 (good).
  • You connected with SET NAMES latin1 (or set_charset('latin1') or ...), probably by default. (It should have been utf8.)
  • The column in the tables may or may not have been CHARACTER SET utf8, but it should have been that.

If you need to fix the data it takes a "2-step ALTER", something like

ALTER TABLE Tbl MODIFY COLUMN col VARBINARY(...) ...;
ALTER TABLE Tbl MODIFY COLUMN col VARCHAR(...) ... CHARACTER SET utf8 ...;

Upvotes: 0

hassan
hassan

Reputation: 8278

you can use set_charset` function

in mysqli

$mysqli->set_charset("utf8")

or you can change the charset from phpmyadmin to utf8_*

Upvotes: 0

Alex
Alex

Reputation: 21766

You can fix the issue by converting your strings to binary and then do charset conversion. The example below converts UTF8 data to CP1251:

UPDATE table SET column=CONVERT(CONVERT(CONVERT(column USING binary) USING utf8) USING cp1251) WHERE id=123;

Upvotes: 1

Related Questions