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

Home -> Community -> Mailing Lists -> Oracle-L -> migrating 8.x->9i and charsets

migrating 8.x->9i and charsets

From: Markham, Richard <RMarkham_at_hafeleamericas.com>
Date: Wed, 25 Sep 2002 20:28:23 -0800
Message-ID: <F001.004D9957.20020925202823@fatcity.com>






migrating 8.x->9i and charsets



Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:<<If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16.>>

the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16.  I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s).  It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16.  I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8.  This test database houses the 11i applications objects.  TIA for any information

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Markham, Richard
  INET: RMarkham_at_hafeleamericas.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 25 2002 - 23:28:23 CDT

Original text of this message

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