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 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 Reddy Bande > > Altair Engg. Inc, > > Troy, MI > > > > -- Cesar D. Rodas http://www.cesarodas.com/ Mobile Phone: 595 961 974165 Phone: 595 21 645590 [EMAIL PROTECTED] [EMAIL PROTECTED]