[...@** 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_value VALUES (0, 1, x'000102030400a0afaabbaa'); sqlite> sqlite> SELECT * FROM periods_value; 0|1| sqlite>
________________________________________________________ how to show the blow data? -- View this message in context: http://old.nabble.com/how-to-show-blob-data-while-select-in-sqlite3-shell--tp26709509p26709509.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
