Support » Fixing WordPress » After upgrade, funny characters appear in the database

  • Rhys Wynne


    Volunteer Moderator

    Hi everybody!

    A client’s blog was recently moved to a new server with the same company. ( Since the move, characters like ’ and  have appeared and I can’t get rid of them.

    Using the WordPress UTF-8 upgrader results in the posts becoming garbled.

    Using the WordPress Search & replace tool gets the following error:-

    in table posts, field post_content: The inquiry could not be implemented: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

    I reckon it is something to do with the way in which mysql differs between each server, but I haven’t been able to remove them. Any suggestions?

  • The topic ‘After upgrade, funny characters appear in the database’ is closed to new replies.