MySQL turns apostrophes into symbols?
Posted on 2007-11-29
I am using, as per my understanding, MySQL version 5.0.45-community.
Using a PHP script, I am retrieving text from a database after inputting it with phpMyAdmin. This text contains apostrophes (the keyboard character, not the ASCII code version).
When that text is outputted to a web page, it appears as a symbol (in Firefox, as a question mark inside a diamond) instead of an apostrophe.
What is causing this, and how can I fix it?