Re: sqlplus: dump function doesn't with unsigned character?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 29 Nov 2002 08:23:26 -0800
Message-ID: <as849u0159i@drn.newsguy.com>

In article <c9d20f14.0211280827.3a15f71b_at_posting.google.com>, cdube_at_mecanica.ca says...
>
>Hello
>
>On unix client workstation I connect to my DB with sqlplus.
>I have a table with raw field (data),
>1 -> insert -> B14458B1...
>2 -> select dump(data,17) from table;
>3 -> I got this -> b1,D,X,b1
>

I would be worried if I got that or this:

>I should get this -> ±,D,X,±
>

the only thing you should get is this:

ops$tkyte_at_ORA920.LOCALHOST> create table t ( data raw(8) );

Table created.

ops$tkyte_at_ORA920.LOCALHOST> insert into t values ( 'B14458B1' );

1 row created.

ops$tkyte_at_ORA920.LOCALHOST> select dump(data) from t;

DUMP(DATA)

---

Typ=23 Len=4: 177,68,88,177

ops$tkyte_at_ORA920.LOCALHOST> select dump(data,16) from t;

DUMP(DATA,16)

---

Typ=23 Len=4: b1,44,58,b1

ops$tkyte_at_ORA920.LOCALHOST> select data from t;

DATA

---

B14458B1

raw is raw -- no translation, I don't understand what you are trying to do here.

Can you post a complete example?

>I played wth NLS_LANG I got the same result
>It looks like I cannot convert unsigned character?
>
>Any ideas?
>
>I have Oracle database created with the following parameters:
> character set US7ASCII.
> national character set US7ASCII
> ....
>Thanks for your help

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 

Received on Fri Nov 29 2002 - 10:23:26 CST