When you use the DBCA to either create a DB or create the scripts to create a DB I presume it picks something up from the OS to help it determine which character set to use when creating the database.
My question is: what does it use?
I have 2 DBs - one 'DB1' on a Windows NT4 server, one 'DB2' on a Windows 2003 server. The character set on DB1 is WE8ISO8859P1, the character set on DB2 is WE8MSWIN1252 and AL16UTF16 NCHAR.
I'm a novice at this type of stuff so would appreciate some pointers.
Would an export from DB1 imported into DB2 give me any real problems? The import works okay but I get a line in the log file saying "possible ncharset conversion".