Re: [sqlite] Forming a query with BLOB with null characters

2008-06-03 Thread Dennis Cote
Shailesh Birari wrote: > Thank you for the input. THis is what I tried, > char*data = "THIS \\\"IS 'BLAH" > This is a blob data of 40 bytes that I wanted to store, so all bytes > after BLAH are all '\0'. No, data is a pointer to a literal character string of length 15. > So I created a insert q

Re: [sqlite] Forming a query with BLOB with null characters

2008-06-03 Thread Shailesh Birari
lesh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Tuesday, June 03, 2008 5:02 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Forming a query with BLOB with null characters >

Re: [sqlite] Forming a query with BLOB with null characters

2008-06-03 Thread Shailesh Birari
bject: Re: [sqlite] Forming a query with BLOB with null characters > > > On Jun 3, 2008, at 4:20 PM, Shailesh Birari wrote: > > > Hello, > > I have a simple question here. I want to generate a insert query > > (char*) > > which will insert a blob in a table. Thi

Re: [sqlite] Forming a query with BLOB with null characters

2008-06-03 Thread Dan
On Jun 3, 2008, at 4:20 PM, Shailesh Birari wrote: > Hello, > I have a simple question here. I want to generate a insert query > (char*) > which will insert a blob in a table. This blob is nothing but a C > structure in my program. > > So the query would be something like this > > INSERT INTO t