Any posts with symbols such as £ or & or ♥ end up being  or worse. It doesn't show in the admin panel on the edit post page, but it is saved in the database as  and shows on the actual live blog as  too.

Here are the relevant tables in the database

And the wp-config snippet:

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', 'utf8');

Believe me, I have tried every single tutorial and tip and suggestion that you can find on Google.

I realise it's a UTF8 encoding issue. But my database is UTF8. My wp-config says UTF8. I've used every plugin and SQL snippet to convert my database, tables and all posts inbetween.

Not a single thing has worked - I've been at this for 3 weeks now and I'm about to explode.

So please... somebody help me!

  • 1
    Please also inspect the actual tables. Just have seen an UTF-8 database that had latin-swedish-ci for only some of the tables. – kaiser Sep 12 '13 at 12:38
  • Please list your exact configuration details. Saying database and WordPress "are UTF8" is too vague. – Rarst Sep 12 '13 at 12:42
  • @Rarst Which configuration details? Like I said, wp-config has "define('DB_CHARSET', 'utf8');" and the collation on everything in the database is "utf8_general_ci". I don't know what other information you need? – NeilSmith Sep 12 '13 at 12:49
  • @kaiser I have checked them all, they are definitely all utf8_general_ci – NeilSmith Sep 12 '13 at 12:50
  • Rarst meant that you copy/paste the details from your config file into the question. Same goes for screenshots of your tables config. – kaiser Sep 12 '13 at 12:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.