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

From: okey <oldyork90_at_yahoo.com>
Date: Sun, 12 Sep 2010 10:35:01 -0700 (PDT)
Message-ID: <684e252c-c69c-465d-81bf-09e1fab77acb_at_c16g2000vbp.googlegroups.com>

On Sep 12, 12:07 pm, okey <oldyor..._at_yahoo.com> wrote:
> 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

Well we used C to dump it.. There are a mix of UNIX and DOS \nl characters. We'll have to convert them all to one or the other... Now, got to figure out that. Received on Sun Sep 12 2010 - 12:35:01 CDT