Sorry if my reply didn't make it through the first time, but doubling up on
the apostrophes worked just fine. My thanks to those of you who suggested
it.
On Thu, Apr 21, 2011 at 4:27 AM, venkat easwar <hareas...@yahoo.com> wrote:
>
>
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
