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

From: Degelis <cdube_at_mecanica.ca>
Date: 12 Dec 2002 08:24:02 -0800
Message-ID: <c9d20f14.0212120824.6e3a79e5@posting.google.com>

Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<as849u0159i_at_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?
>
>

<<<<<<<<<>>>>>>>>>>>>>
Thanks,
Example ->

I do
 select dump(data) from t;
 I got -> Typ=23 Len=4: 177,68,88,177

I do chr(177) I got -> ±

	select chr(177) from dual;
		C
		-
		±

if I do select dump(data,17) from table;
 	-> b1,D,X,b1

I'd like to get	-> ±,D,X,±

Thanks for your time.

Claude

<<<<<<<<<<>>>>>>>>>>>>>>>>

>
>
> >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
Received on Thu Dec 12 2002 - 10:24:02 CST