esday, July 27, 2005 6:13 PM
Subject: Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.
On Wed, 27 Jul 2005, Edwin Knoppert wrote:
I reread the faq hundred times but i don't understand the \000 remark.
For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
C
Wow, super!
I made a very fast converter for that so..
Thanks!
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 27, 2005 6:13 PM
Subject: Re: [sqlite] Sorry, trivail question probably, chr(0)
On Wed, 27 Jul 2005, Edwin Knoppert wrote:
>I reread the faq hundred times but i don't understand the \000 remark.
>
>For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
>Currently i replace all singlequotes with 2x single quotes and that works fine.
>The chr(0) byte did
I will look that up, read something about binding.
But *can* 'escaping' be used as alternative?
- Original Message -
From: "Cory Nelson" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, July 27, 2005 5:41 PM
Subject: Re: [sqlite] Sorry, trivail
in sqlite 3.x you can bind data to prepared statements, no escaping is required.
On 7/27/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote:
> I reread the faq hundred times but i don't understand the \000 remark.
>
> For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
>
I reread the faq hundred times but i don't understand the \000 remark.
For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
Currently i replace all singlequotes with 2x single quotes and that works fine.
The chr(0) byte did not succeed.
I'm using the dll and don't do any c
6 matches
Mail list logo
