Insert Single quotes in SQLite

Question

I'm trying to add the following text to my database: Zeeland '96

But the single quote is giving me errors.

It should look like this:

INSERT INTO Department (Code, Name, CountryID) VALUES ('ZE', 'Zeeland '96', 1)

As you can see, at this moment is one quote missing, how can I get rid of this problem?

Thanks in advance!

http://stackoverflow.com/questions/603572/how-to-properly-escape-a-single-quote-for-a-sqlite-database?rq=1 — Sandy, Mar 04 '13 at 11:34

score 7 · Accepted Answer · answered Mar 04 '13 at 11:29

7

As you can see HERE you need to escape it by using two single quotes in a row. Try:

INSERT INTO Department (Code, Name, CountryID) VALUES ('ZE', 'Zeeland ''96', 1)

answered Mar 04 '13 at 11:29

letiagoalves

score 4 · Answer 2 · answered Mar 04 '13 at 11:29

4

Assuming you're using .NET Library, you can use the SQLiteParameter types to build an SQL command string.

answered Mar 04 '13 at 11:29

Anonymous

score -1 · Answer 3 · answered Mar 04 '13 at 11:32

-1

INSERT INTO Department (Code, Name, CountryID) VALUES ('ZE', 'Zeeland ''96', 1)

answered Mar 04 '13 at 11:32

Akshay Joy

3 Answers3