OK, I figured it out X should be followed by only hex characters 0-9, a-f.
Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI -----Original Message----- From: Prakash Reddy Bande [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 4:00 PM To: sqlite-users@sqlite.org Subject: [sqlite] 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 going wrong? Regards, Prakash Reddy Bande Altair Engg. Inc, Troy, MI ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
