Re: varchar2 to hex/octal ... convert string

"okey" <oldyork90_at_yahoo.com> a écrit dans le message de news: 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

SQL> select dump('michel',16) from dual; DUMP('MICHEL',16)

Regards
Michel Received on Sun Sep 12 2010 - 12:57:06 CDT