Re: migrating 8.x->9i and charsets

The Database Character Set and the National Character Set are different. Your DB CharSet could be UTF8 but the National CharSet AL16UTF16 . [I believe that when you create a database without specifying charsets, the default DB CharSet is still US7ASCII but the NationalCharSet is AL16<something, I can't remember what>]

Where your NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 is defined, your DB CharSet is WE8ISO8859P1.

Hemant

At 08:28 PM 25-09-02 -0800, you wrote:

>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

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).