Re: Reason for upgrading from 8.1.7 to 9iR2

I've seen 9iR2 upgrades driven by a globalization thing rather than performance.

E.g. The UTF-8 support in 9iR2 is much nicer than 8i.
> explain the reasons for moving from 8.1.7 to 9iR2

E.g. in DBA_TAB_COLUMNS the CHAR_USED may be (B)YTES or (C)HAR to differentiate multibyte characters:

--
DEFINE _O_VERSION      = "Oracle9i Enterprise Edition
Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and
Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production" (CHAR)
DEFINE _O_RELEASE      = "902000400" (CHAR)
--
create table foo2 
( col_char_size VARCHAR2 ( 3 CHAR ),
  col_byte_size VARCHAR2 ( 3 BYTE ));

SQL> select char_length, data_length, char_used
  1  from dba_tab_columns
  2* where table_name = 'FOO2'
SQL> /

CHAR_LENGTH DATA_LENGTH C
----------- ----------- -
          3           9 C
          3           3 B

In 8i there were no CHAR semantics which caused
confusion on multibyte charactersets.

Regards,

Mike Thomas



	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------