varchar2 to hex/octal ... convert string

From: okey <oldyork90_at_yahoo.com>
Date: Sun, 12 Sep 2010 10:07:32 -0700 (PDT)
Message-ID: <65276a89-c87b-408c-8975-abde2b69a1e4_at_n7g2000vbo.googlegroups.com>

is there way to 'dump' a string (varchar2) to the screen in hex?

"this is a string" would print something like "33 44 23 64 345 43 34 ..." (I just made that up)

We started using unicode and there are a few fields that should match but do not. We have to see below the characters printed to the screen. Something snuck in there.

We tried using Toad's grid editor to look at this field, but it crumps. Strange.

select char_to_hex(field) from table;

Thank you.
10g Received on Sun Sep 12 2010 - 12:07:32 CDT