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]
Where y
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
[EMAIL PROTECTED]
Each new user of a new sy
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