Re: [sqlite] Usage of special characters in insert query

Escape you input strings: insert into foo values ('I haven''t done that'); On 13/12/06, Kirrthana M <[EMAIL PROTECTED]> wrote: Hi, In my query for inserting values into the database i have a statement as given below insert into table_name values('I haven't done that'); table is created with

[sqlite] Usage of special characters in insert query

Hi, In my query for inserting values into the database i have a statement as given below insert into table_name values('I haven't done that'); table is created with this option create table table_name(str varchar(20)); when the insert statement is executed it gives the error in haven't,It is