Support » Fixing WordPress » WordPress database error: [Illegal mix of collations]

  • 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?

Viewing 1 replies (of 1 total)
  • Try this:

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

Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error: [Illegal mix of collations]’ is closed to new replies.