Special character in varchar in SQL

I am inserting text from a file into a table, few of the lines have words like "you'll" or "don't". When I insert these lines as varchar in my table, I get an error saying - near "ll": syntax e开发者_开发知识库rror. How do I overcome this?

Your single quote is being considered as the end of your string. Escape the quote that exists within your string to avoid this problem.

You need to escape your SQL statement. If you are using SQL Server, then you can use QUOTENAME to resolve this.

Use two apostrophes within apostrophe-quoted strings to insert the apostrophe:

insert into footable (foo) values('you''ll')

Thank you all for responses, since I was using sqlite3, there are inbuilt string formating functions available with the library, so I was able to use sqlite3_mprintf with %q instead of %s and it took care of single quotes.