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
AL16something, 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: [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).