[sqlite] Problem inserting blob

[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 Reddy Bande

Altair Engg. Inc,

Troy, MI