RE: [sqlite] Problem inserting blob

2007-08-31 Thread Prakash Reddy Bande
] Problem inserting blob Hi, I am trying to insert blob in a sqlite database using sqlite.exe . create table t (x blob); insert into t values (x'ccaaffee'); insert into t values (x'ccaa-ffee'); // This line give the error SQL error: unrecognized token: "x'ccaa" Where am I g

Re: [sqlite] Problem inserting blob

2007-08-31 Thread Cesar D. Rodas
insert into t values ("x'ccaa-ffee'"); or insert into t values ('x''ccaa-ffee'''); What you wanna insert must be between " or ' (''[double ' ] is the scape of ') The cleanest way to do is compiling the query On 31/08/2007, Prakash Reddy Bande <[EMAIL PROTECTED]> wrote: > > Hi, > > I am trying

[sqlite] Problem inserting blob

2007-08-31 Thread Prakash Reddy Bande
Hi, I am trying to insert blob in a sqlite database using sqlite.exe . create table t (x blob); insert into t values (x'ccaaffee'); insert into t values (x'ccaa-ffee'); // This line give the error SQL error: unrecognized token: "x'ccaa" Where am I going wrong? Regards, Prakash