Character conversion for database record

Question

Here is my row data:

A windy day looking at open houses Ã°Å¸Ââ€šÃ°Å¸ÂÂÃ°Å¸Ââ€šÃ°Å¸ÂÂÃ°Å¸Ââ€šÃ°Å¸ÂÂ https://t.co/8PCAMxJYaG

I need to convert the character encoding here to be a readable format.

I'm not quite sure how to accomplish this, possibly using php.

Any help would be appreciated.

Declare utf-8 in your database connection to avoid bugs like this — Rehmat, Dec 02 '15 at 20:26
Possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Peter O., Dec 02 '15 at 21:14
That's a mess -- on beyond Mojibake. Please do this to help diagnose: `SELECT col, HEX(col) FROM tbl WHERE ...` — Rick James, Dec 10 '15 at 04:51

score 0 · Answer 1 · answered Dec 02 '15 at 20:31

0

Make sure that your database collation is correct. For accentuated values latin-1 collation is your choice.

If it's right, mind sanitize your input and connection charset.

Cheers!

answered Dec 02 '15 at 20:31

Ivan Cézanne

latin-1 or UTF-8. UTF-8 is better in Linux environments – Hasse Björk Dec 02 '15 at 20:52

1 Answers1