WordPress.org

Ready to get started?Download WordPress

Forums

Strange characters but encoding seems to match (2 posts)

  1. lifedreaming
    Member
    Posted 3 years ago #

    Hi All

    Praying someone can help me solve this: I'm experiencing the symptoms of a character set and collation mismatch between the wpconfig file and the database (ie lots of ''''' and ???? characters appearing when posts and pages are saved, and even in the basic structure such as the blog title), but I can't find the mismatch anywhere.

    My wp-config is set:
    define('DB_CHARSET', 'utf8')
    define('DB_COLLATE', '')

    My server is running MySQL 5.0.45 and phpMyAdmin 2.8.2.4 and the MySQL charset and connection collation is set to utf8_general_ci

    Inside the structure, all the individual fields that are set with a language are also set collation utf8_general_ci

    I've tried many things including changing the wp-config and database to latin1_swedish_ci but nothing seems to make a difference.

    Am I barking up the wrong tree? Is there something else that could be fundamentally wrong?

    An example of what's happening:
    http://www.lifedreaming.me/?p=11

    best wishes
    Marc

  2. lifedreaming
    Member
    Posted 3 years ago #

    Just a follow-up to this, in case anyone comes afterwards with a similar problem and wonders what the outcome was.

    The problem was not a character set and collation mismatch. It was the magic_quotes settings in the PHP.ini file. My ISP had them set to ON, but that was incompatible with WP. I asked them to turn them off and it immediately solved the problem.

    http://www.oracast.com/blog/tag/wordpress-multiple-quotes/
    http://wordpress.org/support/topic/magic-quotes-runtime-bug
    http://www.wowtutorial.org/tutorial/171.html

Topic Closed

This topic has been closed to new replies.

About this Topic