Thanks for the reply Pris; I have already tried a number of sqlite browsers without success. Using them I can export the tables but when I open the resulting html or csv they interpret the hex of the time stamps and jpegs as ascii which chucks out jiberish.
I was wondering if there's a sql query i could run on the whole database which would look at the value in the type field and then handle the data field as either ascii or an image? Pris Matic wrote: > > Maybe you can use a tool like sqlitebrowser to open up the database, then > export tables you want to csv? > > Pris > > On Thu, Nov 17, 2011 at 3:10 AM, si666 <si.for...@gmail.com> wrote: > >> >> I already have, they told me to go away... >> >> >> luuk34 wrote: >> > >> > On 16-11-2011 10:02, si666 wrote: >> >> I have a sqlite database from a iphone chat app which I would like to >> >> present >> >> in a human readable format either csv, html or other. >> > >> > you should ask the author of that iphone app.... ;) >> > >> > >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> > >> >> -- >> View this message in context: >> http://old.nabble.com/Export-Blob-data-from-sqlite-database-to-html-tp32853385p32860354.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Export-Blob-data-from-sqlite-database-to-html-tp32853385p32862284.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
