Hi,
I am trying to insert some text into a table, but the text has some quote characters in it. For example, lets say I have the following table.
CREATE TABLE test ( col1 INTEGER PRIMARY KEY NOT NULL, col2 varchar(255) NOT NULL default '' );
Performing the following insert won't work:
INSERT INTO test ( col2 ) VALUES ('This doesn't work');
because of the ' in the word "doesn't". So I tried escaping the single quote by doing this.
INSERT INTO test ( col2 ) VALUES ('This doesn\'t work');
However this didn't work either. I tried putting double quotes around the value like this:
INSERT INTO test ( col2 ) VALUES ("This doesn't work");
This particular insert worked, however there are cases where I would need to insert text with a double quote as well so I tried the following two inserts:
INSERT INTO test ( col2 ) VALUES ("Test insert with a " in the middle "); INSERT INTO test ( col2 ) VALUES ("Test insert with a \" in the middle ");
I already have this working in MySQL and PostgreSQL and am trying to add support for SQLite. I am definitely a novice of SQLite. Is there some way to properly escape single and or double quotes, or do I have some obvious syntactical error? Any help would be great. Thanks.
~Mike