Storing of Quotation Mark Characters in Database

I am storing large amounts of text in a database. The problem is that when I try to store quotation marks (‘ ’ “ ” not " ') they store in the database fine although do not show when I show the text from the database.

Should I convert the quotation marks before putting them 开发者_如何转开发into the database or on loading the text from the database and what method of converting them would be best suited?

Your problems would indeed be solved by using UTF8, but if this does not comply with your front end, then just resort to html entities.

This tool should be useful if you cannot use php\something else to do it automaticly: http://leftlogic.com/projects/entity-lookup

Could you store them as “ and ” or ‘ and ’?

I am presuming the output is in html?