encoding - data porting in mysql -

While porting another database from a mysql database, there have been some issues such as apostrophes being converted into a field Is the story Why did this happen and now what should I do to correct the new database?

I have phpmyadmin access to only two databases.

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 letter: latin1db alphabet: latin1 client password: latin1con. Letters: Latin 1  

Which characters do you get and what do you expect?