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 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]> >