2009/9/21 Yan Bertrand <yan.bertr...@polestar.eu>: > Hi all, > > > > I would like to display the contents of blobs in my table as > hexadecimal. I have not found any easy way of doing this. I tried : > > - wxSQLitePlus, but it does not display blobs contents (or I > could not make it do so) > > - SQLiteManager plugin (for Mozilla Firefox), but it does not > do this by default. The website says it can but the explaination for it > is still < to be done >. > > - SQLiteStudio does not display anything (it says < NULL > in > italic, but it is not a NULL content.) > > - SQLite2009 Pro but it does not dosplay blobs either > > - I could dump the table but it really gets tedious. > > > > Note: I tried exporting to other formats but the blobs are replaced by a > string (either < NULL > or < NONE >). I know my blobs are not empty > because C-code can read them. > > > > Any idea? >
>From sqlite shell command line (or equivalent in you GUI of choice) execute select hex( yourBlobColumnName ) from yourTable; > > Thank you for your support and merry continued use of SQLite! > > Yan > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
