Thanks!!!
SimonDavies wrote: > > 2009/12/9 liubin liu <[email protected]>: >> >> sqlite> INSERT OR REPLACE INTO periods_value VALUES (0, 1, >> x'000102030400a0afaabbaa'); >> sqlite> >> sqlite> SELECT * FROM periods_value; >> 0|1| >> sqlite> >> >> how to show the blob data? > > Select id, valid, hex( value ) from periods_value; > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/how-to-show-blob-data-while-select-in-sqlite3-shell--tp26709509p26709778.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
