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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users