Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

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

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

Questions on WordPress Development Stack Exchange are expected to relate to WordPress within the scope defined by the community. 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 reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the 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

1 Answer 1

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.