I wrote a byte to hex converter which is very fast.
I'm very pleased with the poss. of using the X'' notation.
Saves all kinds of (future?) problems.
----- Original Message -----
From: "Cory Nelson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, July 31, 2005 7:58 PM
Subject: Re: [sqlite] quoting
strings should be surrounded by single quotes, so only single quotes
and null bytes need to be quoted. but, it would be faster to use
binding and not have to deal with quoting.
On 7/31/05, Jakob Hirsch <[EMAIL PROTECTED]> wrote:
Hi,
SQLite happens to be a nice piece of software, so it is about to be
integrated into the Exim MTA.
Exim provides a quoting function for every database it supports, so will
be for SQLite.
Is it correct that the only character that needs to be encoded is the
single quote (')?
While testing I saw the double quote is somewhat equivalent to the
single quote, which gives a little trouble. Exim's quoting function
cannot know, which type of quotes surround, so it will possibly fail if
someone uses double quotes. Is there probably a better way to do that?
(like escaping with \ all possible quoting chars, i.e.)
--
Cory Nelson
http://www.int64.org
