Re: Hex display in sqlplus possible?

From: Scott Mattes <ScottMattes_at_yahoo.com>
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

Original text of this message