Answered Moved site and some ASCII characters have been replaced with symbols

Hello

I've recently moved a site from one server to another and all has gone well this time (I learnt from a previous move/post here) except that some ASCII symbols have been replaced with symbols (e.g. apostrophe becomes ’). This has happened in some places but not others, in both richtext and normal textareas.

Is there a more automated solution to revert them site-wide (reimporting the SQL file etc) rather than going through and manually changing all the occurrences?

Thanks [ed. note: cottoncreative last edited this post 11 years ago.]

Are you sure that your databases are using the same charset and collation? BobRay has a script to help with collation and charset mismatches.

http://bobsguides.com/convert-db-utf8.html

I think you might be right, the original was Latin1 the new one is UTF8.
I keep getting errors using BobRay's script when copying the SQL from the cnc.php generated text.

Error
SQL query:

ALTER TABLE modx_access_actiondom DROP INDEX `target` ;
MySQL said: Documentation

#1091 - Can't DROP 'target'; check that column/key exists

Any ideas?
When I compared the two downloaded sql files there are more differences than just the timestamp. A few auto-increments were also different, should I correct those in the sql before proceeding with the instructions?

id guess deleting core/cache folder and creating a new one. Maybe rerun setup then

Thanks all.

I had already succumbed to the best idea being to reinstall it all. So I did and kept the Latin1 collation and it's all running fine now. I'll give Bob's script a go again at some point but I guess 'if it ain't broke' and all that...