What kind of database you are using ?
In MySQL for example there is an escape character backslash ( \ ) which allows you to work with some special characters in a string:
I think there must be an equivalent in MSSQL or others.
\\' A single quote character.
\" A double quote character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\\ A backslash character.
First you have to replace all single quotes in your strings to ( \\' ) and than insert them to database:
YourNewString = Replace(YourString,"'","\\'")
SQLtext="insert into YourTbl(Colname) values('" & YourNewString & "')"
Sweet smell of a great sorrow lies over the land. Plumes of smoke rise, merge into the leaden sky. A man lies and dreams of green fields and rivers, but awakes to a morning with no reason for waking. He's haunted by the memory of lost paradise. In his youth or dream, he can't be precise. He's chained forever to a world that's departed. It's not enough, it's not enough.