Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sqlplus: dump function doesn't with unsigned character?
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 ....