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
Title: migrating 8.x-9i and charsets
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
Title: RE: migrating 8.x-9i and charsets
what I found odd after reading the migration manual is that the 9i
upgrade database is still showing:
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1
I haven't found any issues with functionality, keeping in mind this
two tier