Hi,

I have texts stored in MySQL. When I extract and display them, there are no problems with the standard characters except with the double quotes and single quotes (" and ') have problems displaying. They display like this “ or like this ’. The MySQL's data type I use is text. I'm sure it's nothing to do with the data type. I heard about charsets but I'm not familiar with them.

Please help. thanks.

There are reserved symbols you cannot use in strings. I'd suggest not using and storing " or ' within your databases.

Try using htmlspecialchars on the text you want to store to convert the quotes to the HTML equivalents.

http://www.php.net/htmlspecialchars

There are reserved symbols you cannot use in strings. I'd suggest not using and storing " or ' within your databases.

You certainly can store those characters in a database without problem. Sounds like the problem is with PHP, not MySQL.

Sorry, duplicate.

What is the source of your data? Are those quotes avrually curly quotes? You will need to convert these in some way before putting them in the database

it because the difference between " - made by notepad and " - made by text editor such as microsoft word...
to avoid " - made by ms.word, usually i copy the entire text to notepad, then insert it to the DB..