I don't know if what I want to do is possible or not.
I have a schema that has a couple of BLOB columns where the data is
either:
1. Really random, or
2. May contain leading 0's
Either way, the results aren't really readable with SELECT using the
sqlite command line tool. Are there any
Shane Baker [EMAIL PROTECTED] wrote:
Are there any mechanisms that will display the [BLOB]
data in a human readable format?
Assuming the table is: CREATE TABLE t1(x BLOB)
You can do this:
SELECT quote(x) FROM t1;
For that matter, can I view an INTEGER
column as hex in the output window?
Thanks very much, the quote() helps a lot.
On Mon, 30 Jan 2006 [EMAIL PROTECTED] wrote:
Shane Baker [EMAIL PROTECTED] wrote:
Are there any mechanisms that will display the [BLOB]
data in a human readable format?
Assuming the table is: CREATE TABLE t1(x BLOB)
You can do this:
SELECT