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?

Not without modifying the shell to implement some kind
of custom function to do so.  At least no way that I can
think of right off hand.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Reply via email to