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?