>Something like (one line, wrapped by email): > >echo "INSERT INTO t1 (id,pic) VALUES (1,X'$(od -A n -t x1 >picture.gif | tr -d '\r\n\t\ ')')" | sqlite3 mydb > >(The od utility may be smarter than that, optimization left >to the OP)
Looks good, you know better than I do. Just checked: od and tr are available under MinGW. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users