Tell me more ×
WordPress Answers is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.
up vote -1 down vote favorite

I moved my hosting provider and now the encoding is messed up. See here for example. In the past commenting out the follwoing lines fixed the issue for me, but not this time:

//define('DB_CHARSET', 'utf8');

//define('DB_COLLATE','utf8_unicode_ci');

The hosting provider is saying I need to set it to the correct encoding rather than just comment it out, but I'm unsure what encoding that would be.

Example Text:

You’ll be in good company. Join our network of leading RC sponsors that have help support the growth of HeliReviews.

share|improve this question
possible duplicate of How do I remove weird characters in text? – kaiser Apr 29 '12 at 18:55
That questions says the symbols just appeared, whereas this item is about encoding after moving hosts. – Adam May 1 '12 at 0:57
Close-voted as off-topic. This question appears to be a SQL data/import issue, rather than a WordPress issue. – Chip Bennett May 1 '12 at 14:35

closed as off topic by kaiser, Chip Bennett, toscho♦ Jul 14 '12 at 1:55

Questions on WordPress Answers are expected to relate to WordPress within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 2 down vote

The reason commenting out (see q ) didn't work is that the data was wrong in the database, so no encoding change could fix it.

I restored the database by copy pasting the sql script into PHPMyAdmin, and the text box interpreted the text as having the wrong encoding. By using import in phpmyadmin and selecting the file, that data came in correctly.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.