Not sure. I haven't had the time to play with 9.x and character sets yet. Our
instance currently
is 8.1.7.4 and was created as UTF8 since we had to support Simplied Chinese and
Portuguese from the
onset of the 11.5 project.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
09/25/02 09:28 PM cc:
Please respond to Subject: migrating 8.x->9i and
charsets
ORACLE-L
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: Ron Thomas
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
