Text coming from database with lots of question marks

[bobococo]

Hello,

Here is my problem. I have a web site with a MySQL database and I initialy used MySQL 4.0.22 database but now I've moved to a new server that uses the version 4.1.11 MySQL. By doing this all the apostrophes from all the text got replaced by question marks and there are some random question marks throughout the text.
Does anybody know how to fix that?

Thank you,
FM

[dmnet]

not 100% sure that this is the problem but it could be - what charset are you using? does the server you have just moved to have the same charset as your pages? incorrect charset will throw some punctuation marks out.

Hope this helps, if it doesnt, sorry.

Cheers

[cnperry]

I'm having a similar problem - but it seems to only be occurring with singe quotes.

When putting the text entry into the database I strip html tags, convert to special characters, and run it through the mysql real escape function. When the text is spit back out on the page the single quotes will either be blank (safari) or will be a question mark (firefox). Actually firefox formats the text really really weird whereas other browsers do not. But that's neither here nor there.

Any ideas about what to do with the single quote issue?