data porting problem in mysql

Question

in porting data from one mysql database to other .. there have come some errors like appostrophe's have got converted into †.. in a field called story . why did this happen and what should i do now to correct the new database.

i have only the phpmyadmin access of the two databases

Answer 1

Take a look at the charatersets used by your database. You can do this by entering \s in the MySQL client. Example output is:

Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1

What charactersets do you get and what do you expect?