WordPress.org

Ready to get started?Download WordPress

Forums

WordPress database error: [Illegal mix of collations] (2 posts)

  1. ArchStanton
    Member
    Posted 7 years ago #

    I recently upgraded from MySQL 4 to 5 and I think the collation got messed up. When leaving a comment the following error is received:

    WordPress database error: [Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=']

    How can I fix that?

  2. danielkwan
    Member
    Posted 6 years ago #

    Try this:

    ALTER TABLE 'wp_comments' CHANGE 'comment_content' 'comment_content' TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.