| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: migrating 8.x->9i and charsets
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
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan
root_at_fatcity.com
To: ORACLE-L_at_fatcity.com
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: rthomas_at_hypercom.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 Thu Sep 26 2002 - 13:17:05 CDT
 |
 |