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.