how to show the equivalent hex value of integer data while select in sqlite3 shell?
sqlite> sqlite> CREATE TABLE test (id INTEGER, data INTEGER); sqlite> INSERT INTO test VALUES (1, 32); sqlite> SELECT * FROM test; 1|32 sqlite> sqlite> sqlite> SELECT hex(data) FROM test; 3332 ### hope to get 0x20 sqlite> -- View this message in context: http://old.nabble.com/how-to-show-the-equivalent-hex-value-of-integer-data-while-select-in-sqlite3-shell--tp27009563p27009563.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