Update database encoding error | WordPress.org

thomasreggi
(@thomasreggi)

14 years, 2 months ago

I had an outdated database and wordpress recognized it and requested to update it. Now I have some messed up posts here is an example of the text.

world?â€¦Oh Iâ€™ll go to Hulu and watch the latest Daily show; what is everyone up to? â€¦lets head over to Facebook.Â Lit

It looks like it has been character encoded wrongly. Any ideas?

Viewing 3 replies - 1 through 3 (of 3 total)

Tim S
(@tim-s)

14 years, 2 months ago

What character encoding are you using? Changing the character encoding of a database is a nightmare. I’d suggest making sure you’re using UTF-8. If you’re not, and your site is in english – you may want to collate the database to UTF-8. IF you do this though, it will not affect any content already in the database. I hope this helps!

Thread Starter thomasreggi
(@thomasreggi)

14 years, 2 months ago

This post helped me out a bunch:
http://joemaller.com/1328/fixing-mixed-encoding-mysql-dumpfiles-with-wordpress/

Tim S
(@tim-s)

14 years, 2 months ago

I’m glad you found the answers you were looking for. I hope all is well.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Update database encoding error’ is closed to new replies.

Tags

In: Installing WordPress
3 replies
2 participants
Last reply from: Tim S
Last activity: 14 years, 2 months ago
Status: not resolved

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics