Hello Petr, You could Mime encode them to text, insert as a string. Pull them back out as strings, un-mime them. Should be able to do that from a batch file.
I keep a bunch of images in Sqlite DB files. It's reasonably fast and I like having them all in one place. Some of the DB files are > 10 GB. C Wednesday, January 18, 2012, 10:14:17 AM, you wrote: PL> Because of packing. The script should be distributable as one PL> .cmd file, the database engine and database itself will be embeded PL> inside od script. Dealing with embeded files in the shell script PL> is not easy thus I want to minimize its number. PL> L. >> On Jan 18, 2012, at 12:00 PM, Petr Lázňovský wrote: >>> have windows batch working with sqlite, may I insert image into database >>> and than read this images from? >> As pointed out, you might want to use the 'blob' type to store binary data. >> That said, why bother storing these images inside the database itself? Any >> benefit in doing so? >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users PL> _______________________________________________ PL> sqlite-users mailing list PL> sqlite-users@sqlite.org PL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users