>True. I will get rid of the habit of using double quotes for string
>literals.
>Thanks for information. But most of the databases support this non
>standard
>behavior.
Yeah ... until things break under your feet due to a new version not
sticking to the "non-standard" behavior anymore or pars
Database
Sent: Thu, April 21, 2011 4:03:49 PM
Subject: Re: [sqlite] How to Use an Apostrophe in a Text Field?
> The apostrophes are escaped by apostrophes.
Correct. http://www.sqlite.org/faq.html#q14
> One more way you can do.
>
>insert into () values ("*Goin' Down
>
> The apostrophes are escaped by apostrophes.
Correct. http://www.sqlite.org/faq.html#q14
> One more way you can do.
>
>insert into () values ("*Goin' Down
> >> the Road Feelin' Bad*");
>
>It is double quotes before and after *. Similarly double quotes will
>be escaped by one more double qu
___
> From: Jim Morris
> To: General Discussion of SQLite Database
> 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'' B
From: Jim Morris
To: General Discussion of SQLite Database
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 P
Thanks to all for all the suggestions. Doubling up the apostrophe worked.
On Mon, Apr 18, 2011 at 10:55 AM, Jim Morris wrote:
> 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 Holb
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 wr
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 *Goi
On Sun, Apr 17, 2011 at 3:54 PM, 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
On Apr 17, 2011, at 5:54 PM, 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
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
correc
11 matches
Mail list logo