Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!headwall.stanford.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: cdube@mecanica.ca (Degelis)
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: sqlplus: dump function doesn't with unsigned character?
Date: 12 Dec 2002 08:24:02 -0800
Organization: http://groups.google.com/
Lines: 89
Message-ID: <c9d20f14.0212120824.6e3a79e5@posting.google.com>
References: <c9d20f14.0211280827.3a15f71b@posting.google.com> <as849u0159i@drn.newsguy.com>
NNTP-Posting-Host: 193.42.138.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1039710242 4478 127.0.0.1 (12 Dec 2002 16:24:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2002 16:24:02 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90474 comp.databases.oracle.server:169521
X-Received-Date: Thu, 12 Dec 2002 09:23:38 MST (news.easynews.com)

Thomas Kyte <tkyte@oracle.com> wrote in message news:<as849u0159i@drn.newsguy.com>...
> In article <c9d20f14.0211280827.3a15f71b@posting.google.com>, cdube@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@ORA920.LOCALHOST> create table t ( data raw(8) );
> 
> Table created.
> 
> ops$tkyte@ORA920.LOCALHOST> insert into t values ( 'B14458B1' );
> 
> 1 row created.
> 
> ops$tkyte@ORA920.LOCALHOST> select dump(data) from t;
> 
> DUMP(DATA)
> ----------------------------------------------------------------------------------------------------
> Typ=23 Len=4: 177,68,88,177
> 
> ops$tkyte@ORA920.LOCALHOST> select dump(data,16) from t;
> 
> DUMP(DATA,16)
> ----------------------------------------------------------------------------------------------------
> Typ=23 Len=4: b1,44,58,b1
> 
> ops$tkyte@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