phpMyAdmin replacing ' char with Õ

In the process of inserting data from a comma-separated csv textfile into a table using phpMyAdmin, any ' characters get turned into Õ. Now I understand that the ' character is used in MySQL for commands and might cause problems in the syntax if they were left in without the \ in front to identify them as part of the text. However, will I have to run through all 5000 records adding \ where necessary or is there a better way of doing it? or is only me that is using words like ShakespeareÕs Globe and YesterdayÕs World! ....and why does it pick such an obscure character?
Sorry if this is not the first time anyone has been asked this on this forum.

You're problem's not a conflict in MySQL with the ' character, exactly. I'm guessing that the file you're pulling the info from has been generated with 'smart quotes' -- that is, curved, comma-like apostrophes. When translating these, especially across platforms, they're often mistranslated from the apostrophe to the big O instead of '. If you open your file in a code editor, it'll probably do the same thing -- then you can just find and replace your O's with ''s before dumping into your db.

Hi Madpawn

You are probably right about the dubious character ', The database started out in life as a Filemaker file and is then converted to a csv file. But I am not aware that the conversion a took place then to a Õ. So these quote marks in filemaker could be not the same as a common ' . Ummmm that's interesting!