MySQL Forums
Forum List  »  Other Migration

strange characters in data after migration
Posted by: Chad Horton
Date: March 17, 2006 05:47PM

Hello,

We migrated our sites from one server to another along with our MySQL databases. I now see strange characters in the data, such as ’

These seem to be characters that are replacing other characters such as ' or other characters.

How can I fix this so

1. existing data has the correct characters
2. moving forward new data added will not have these characters.

I have always had my collation set to latin1_swedish_ci, even between both servers before migration.

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
strange characters in data after migration
3228
March 17, 2006 05:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.