On 6 Apr 2014, at 9:01pm, <to...@acm.org> <to...@acm.org> wrote:
> I haven't figured out how to load a blob (e.g., image) from the shell. I
> would think there should be something like this but can't find anything:
>
> insert into table values(file('path_to_binary_file'));
You can represent a blob as text by expressing it in hexadecimal:
0xDEADBEEF
would be a four octet BLOB.
So you might be able to use something like hexdump to create an appropriate
INSERT or UPDATE command.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
