The MU forums have moved to WordPress.org

database type issues (2 posts)

  1. anointed
    Member
    Posted 13 years ago #

    I've had problems from the very first day I installed my blog about a year ago. Basically if I put in any character like ( ’ ) instead of ' and click submit article, it always cuts my article off right there. This happens for virtually any character I try to add to a story.

    So I did some digging around the forums and I think I found my problem.

    My wp-config file has the following:

    define('DB_CHARSET', 'utf8');

    If I change 'utf8' to 'utf-8' then I can put in all the characters like above into the article and it works.

    However:
    I went into my server error logs and noticed tons of errors saying it was an unrecognized database type even though it was accepting it.

    Obviously I can't just change utf8 to utf-8 and expect it to work properly.

    My question:
    How do I go about changing the actual database type to match utf-8 so it will work properly without all the errors?

    secondly:
    why does wpmu come with the config as utf8 instead of utf-8?

    Or am I just completely off base here?

    All I want is to be able to cut n paste an article without having to make sure it contains no characters at all, it's to much a pain to use that way.

  2. tdjcbe
    Member
    Posted 13 years ago #

    Ours are set in our .htaccess file as:

    AddDefaultCharset UTF-8

    Although the third post in this thread says it doesn't work for php:

    http://www.webmasterworld.com/forum88/11331.htm

    But we also have the line that you do in our wp-config.php file as well.

    Hmmm. Not a clue to be honest.

    Please check to see what database type your databases are currently in. If they're not utf8_general_ci, best bet would be to delete and start over if you can.

About this Topic