This content has been marked as final. Show 2 replies
Not exactly a bug. It is more the nature of delimiters and separators.You will find identical results in most web applications.The SQL standard specifies that single-quotes in strings are escaped by putting two single quotes in a row.
I recently encountered the same thing. I now just leave the apostrophe out to stop the text from getting truncated.