Re: migrating 8.x-9i and charsets

2002-09-27 Thread Hemant K Chitale
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

migrating 8.x-9i and charsets

2002-09-25 Thread Markham, Richard
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

RE: migrating 8.x-9i and charsets

2002-09-25 Thread Markham, Richard
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