>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

Reply via email to