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