I am posting ntext to a SQL database. I know that I need to replace all apostrophes with double apostrophes and replace one quote with double quotes.
What else do I need to do to a string before submitting to a database? Also, I need to be able to easily retrieve them....right now by replacing a single quote with a double quote, it retrieves without any extra code. So I need to know if there's anything else pre-submit I need to do to a string, as well as post-retrieve that I need to get the original string back again.