On Wed, Mar 30, 2011 at 12:35:42PM -0400, Santin, Gloria scratched on the wall:
> To all,
> Is there any way to insert into a BLOB field using the insert statement?
BLOB literals are given as hex strings, with a proceeding 'X'. For
example:
X'deadbeef'
is a 4-byte BLOB. You would use it like this:
INSERT INTO table ( b_col ) VALUES ( X'deadbeef' );
More info:
http://sqlite.org/lang_expr.html
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
