RE: Database Character set related question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mandal, Ashoke Sent: Thursday, October 27, 2005 12:42 PM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 27 2005 - 12:14:56 CDT