Re: [sqlite] how to show blob data while select in sqlite3 shell?

Thanks!!! SimonDavies wrote: > > 2009/12/9 liubin liu <7101...@sina.com>: >> >> 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,

Re: [sqlite] how to show blob data while select in sqlite3 shell?

2009/12/9 liubin liu <7101...@sina.com>: > > 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] how to show blob data while select in sqlite3 shell?

[...@** createdb]$ [...@** createdb]$ sqlite3 ./db_ctrl_0.1.db SQLite version 3.6.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE periods_value (id INTEGER PRIMARY KEY, valid CHAR(1), value BLOB ); sqlite> sqlite> INSERT OR REPLACE INTO periods_va