On Thu, 10 Dec 2009 04:57:58 +0100, Jean-Christophe Deschamps <j...@q-e-d.org> wrote:
> is to >use a command-line tool or combination thereof that will open your >binary file, read each byte in turn and output its hex value in plain >ASCII characters, until end of file. 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) >That (possibly long) chain of >text can be stored as a single BLOB without any problem using for >instance an SQL file fed to sqlite3.exe. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
