] 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'cc
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
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 Redd
3 matches
Mail list logo