Re: [sqlite] Quoting strings for SQLite

2010-04-20 Thread Dan Bishop
Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/18/2010 11:03 PM, Dan Bishop wrote: > >> I've written a quoting routine too, in C++. I just truncated strings at >> the first NUL character because I didn't think that SQLite supported them. >> > > SQLite suppo

Re: [sqlite] Quoting strings for SQLite

2010-04-19 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/18/2010 11:03 PM, Dan Bishop wrote: > I've written a quoting routine too, in C++. I just truncated strings at > the first NUL character because I didn't think that SQLite supported them. SQLite supports some weird things. In addition to suppo

Re: [sqlite] Quoting strings for SQLite

2010-04-18 Thread Dan Bishop
Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/17/2010 07:12 PM, Dan Bishop wrote: > >> Newlines, backslashes, and double quotes can be included literally. The >> only other character you need to worry about is NUL. >> > > Funnily enough I'm busy writing my

Re: [sqlite] Quoting strings for SQLite

2010-04-18 Thread Simon Slavin
So I'm summarising for the net. To render a string into quotable form (1) Replace each apostrophe in it with two apostrophes. (2) Surround it with single apostrophes. That's all there is to worry about apart from 0x00 characters, which don't worry me for other reasons. Do those two things and

Re: [sqlite] Quoting strings for SQLite

2010-04-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/17/2010 07:12 PM, Dan Bishop wrote: > Newlines, backslashes, and double quotes can be included literally. The > only other character you need to worry about is NUL. Funnily enough I'm busy writing my own quoting routine right now (the source ar

Re: [sqlite] Quoting strings for SQLite

2010-04-17 Thread Dan Bishop
Simon Slavin wrote: > I am using a particular program which needs to be able to mess with an > already-established database. It has to issue UPDATE and INSERT commands > using one string for the entire command: no opportunity for binding. So it > has to assemble commands by concatenation. In

Re: [sqlite] Quoting strings for SQLite

2010-04-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/17/2010 01:26 PM, Simon Slavin wrote: > Is there a simple, low-cost way I can use the QUOTE() function, http://www.sqlite.org/c3ref/mprintf.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with

[sqlite] Quoting strings for SQLite

2010-04-17 Thread Simon Slavin
I am using a particular program which needs to be able to mess with an already-established database. It has to issue UPDATE and INSERT commands using one string for the entire command: no opportunity for binding. So it has to assemble commands by concatenation. In order to do this properly I