Re: varchar2 to hex/octal ... convert string
From: Frank van Bortel <fbortel_at_home.nl>
Date: Wed, 15 Sep 2010 10:10:46 +0200
Message-ID: <13e40$4c907f86$524ba3af$9622_at_cache4.tilbu1.nb.home.nl>
On 09/12/2010 07:57 PM, Michel Cadot wrote:
> "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)
> -------------------------------
> Typ=96 Len=6: 6d,69,63,68,65,6c
>
> Regards
> Michel
>
>
Oops - replied before reading all of the thread
Date: Wed, 15 Sep 2010 10:10:46 +0200
Message-ID: <13e40$4c907f86$524ba3af$9622_at_cache4.tilbu1.nb.home.nl>
On 09/12/2010 07:57 PM, Michel Cadot wrote:
> "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)
> -------------------------------
> Typ=96 Len=6: 6d,69,63,68,65,6c
>
> Regards
> Michel
>
>
Oops - replied before reading all of the thread
-- Regards, Frank van BortelReceived on Wed Sep 15 2010 - 03:10:46 CDT