Look like script for different platform, but "od" and "tr" are available also for Win so I will try...
> On Wed, 18 Jan 2012 13:30:49 +0100, Petr Láz?ovský <la...@volny.cz> > wrote: >>>> have windows batch working with sqlite, may I insert image into database >>>> and than read this images from? >>> Convert your image into a BLOB and store it as a BLOB. BLOBs are just runs >>> of bytes -- you can store anything you want as a BLOB. >>What you mean by "Convert image into a BLOB" is there some kind of SW to do >>this? Does SQLite offer some way to do this? Sorry for dumb question, but I >>googling about this some time with no luck.. >>I found only http://www.vive.net/products/image2db.htm but this is GUI tool, >>not suitable for scripting.. > Try this one liner demo (wrapped by mail) to insert file contents into a > database table: > d=test.db3 ; echo "CREATE TABLE Files (name TEXT PRIMARY KEY,contents > BLOB);" | sqlite3 $d ; for f in yourfiles* ; do echo "INSERT INTO Files > (name,contents) VALUES ('$f',X'$(od -v -A n -t x1 $f|tr -d '\r\n\t > ')');" | sqlite3 $d ; done > I'll leave the extraction from database to files as an exercise for the > reader. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
