Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sqlplus: dump function doesn't with unsigned character?

sqlplus: dump function doesn't with unsigned character?

From: Degelis <cdube_at_mecanica.ca>
Date: 28 Nov 2002 08:27:59 -0800
Message-ID: <c9d20f14.0211280827.3a15f71b@posting.google.com>


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 should get this -> ±,D,X,±

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 Nov 28 2002 - 10:27:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US