After upgrade, funny characters appear in the database (1 post)

  1. Rhys Wynne
    Volunteer Moderator
    Posted 7 years ago #

    Hi everybody!

    A client's blog was recently moved to a new server with the same company. (offices.networkyachtbrokers.co.uk) 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?

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.