The apostrophes are escaped by apostrophes. One more way you can do.
insert into <table name> (<column name>) values ("*Goin' Down
>> the Road Feelin' Bad*");
It is double quotes before and after *. Similarly double quotes will be escaped
by one more double quote
VENKAT
________________________________
From: Jim Morris <jmor...@bearriver.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Mon, April 18, 2011 8:25:54 PM
Subject: Re: [sqlite] How to Use an Apostrophe in a Text Field?
Did you try doubling the apostrophes?
*Goin'' Down the Road Feelin'' Bad*
On 4/17/2011 6:16 PM, Simon Slavin wrote:
> On 17 Apr 2011, at 11:54pm, Alan Holbrook wrote:
>
>> I'm using SQLite with VBE2008. I've defined a table with a number of text
>> fields in it. If the information I want to write to the database contains
>> an embedded apostrophe, the program throws an error. That is, if I set
>> textfield1 to *Going Down the Road Feeling Bad*, the data gets written
>> correctly and the program continues. But if I set textfield1 to *Goin' Down
>> the Road Feelin' Bad*, I get an error.
>>
>> Is there a way I can use an apostrophe in the data to be written?
> Your library might do it for you. If you're writing directly to the SQLite
>library then I believe you can double the apostrophe:
>
> Goin'' Down the Road Feelin'' Bad
>
> so it might be worth trying that.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
