Re: Hex display in sqlplus possible?
Date: Wed, 27 Mar 2002 18:56:44 GMT
Message-ID: <MBoo8.464$SG2.40566_at_news1.news.adelphia.net>
try dump()
SQL> desc dual;
Name Null? Type ----------------------------------------- -------- ------------------------ ---- DUMMY VARCHAR2(1)
SQL> select dump( dummy ) from dual;
DUMP(DUMMY)
Typ=1 Len=1: 88
SQL> select * from dual;
D
-
X
SQL>
"Paul Donaldson" <pdonaldson_at_versatilemobile.com> wrote in message
news:ae529a80.0203271027.22701d32_at_posting.google.com...
> Hello,
>
> I have a Java application that is reading in XML and writing to an
> Oracle database.
>
> The XML contains accented charcters (e.g. 'e' with acute accent [é])
>
> When I view the XML using 'vi' I can see the data correctly if I have
> the LANG enviromment variable set to, for example, en_US.
>
> When I use the command line tool 'sqlplus' to view the contents of my
> table, the accented character is shown as a '?', regardless of the
> setting of LANG. This suggests to me that it really is a question mark
> on the database and that there is a problem with my application.
> However, I would like to eliminate the possibility that the character
> really is an é on the database but that sqlplus is unable to display
> it correctly.
>
> Which brings me to my question (at last I hear you say) - is there any
> way I can get a hex representation of the data on the database? I
> thought I might be able to "SET" something from within sqlplus but I
> can't see anything relevant.
>
> The OS is Solaris 7.
>
> Any help most appreciated.
>
> Thanks,
> Paul
Received on Wed Mar 27 2002 - 19:56:44 CET