[sqlite] Usage of special characters in insert query

[Kirrthana M]

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
working fine if i remove the apostrophe,
but my input string will contain the apostrophe..
Give me a suggestion for rectifying this....

Thanks,
Kirrthana