RE: Database Character set related question
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Oct 2005 13:10:48 -0400
What are the decimal values for these unprintable characters. We use
US7ASCII and I know that values greater than 127 are recognized as being
specific symbols such as decimal 162 is the cent sign.
Get the decimal values for the bytes in question and compare them to the
result of the following code:
set echo off
--
-- pl/sql script to identify ASCII print symbols
--
-- 20030327 Mark D Powell New figure out ASCII char 4 squared n cubed
--
set serveroutput on size 32768
set trimspool on
spool ascii_sym
declare
--
v_string varchar2(1) := null;
v_dec_val number(3) := 0 ;
--
begin
--
for I in 1 .. 255 loop
select chr(I) into v_string from sys.dual;
dbms_output.put_line(to_char(I,'009')||'= '||v_string);
end loop;
end;
/
spool off
Note that Tab (009) and Newline (010) will not produce readable output.
If you can identify a valid value for the data in question then maybe
the spool file might help if the conversion process changes the values
and the result is not correct.
HTH -- Mark D Powell --
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mandal, Ashoke
Sent: Thursday, October 27, 2005 12:42 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database Character set related question
Greetings All,
The database CHARACTER SET is US7ASCII. The data in the database
contains 8 bits (> 127 ASCII ) values. We cannot display these
values, instead we see "?" character via the sqlplus session.
We want to upgrade this database to 9.2.0.4, but before we do that ,
we want to make sure that we don't lose any characters that are
currently stored in the database.
We are attempting to run CSSCAN to verify. We want to use UTF8 in the
new 9i
database. How do we determine what the character set was used to put
the data into the database.
It's definitely not US7ASCII!
Is there a object that we can look at to see what another session is
currently using? It is difficult for us to get access to the user 's
workstation to see there configuration.
Thanks,
Ashoke
Other related posts: