-
Default Character sets on Windows
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".
-
I think DB1 is probably Oracle 8i db, whereas DB2 might be Oracle 9i db
-
Exactly this is because of different versions of oracle and also the import works because WE8MSWIN1252 is a superset of WE8ISO8859P1.
-
Correct about the versions chaps!
Can you elaborate?
Should the import/export function ok? Or will there be possible character conversion problems?
-
Oracle takes default characterset as WE8ISO8859P1 for 8i and WE8MSWIN1252 for 9i during their database creation.Since both are supersets u willn't have any problem with the data even though it mentions as possible conversion at the time of import.
Last edited by akhadar; 11-24-2004 at 06:10 AM.
-
We have a Trademark symbol ™ in our 8i database. I did an export and imported it into a 9i database. It appears in the 9i database as ¿. I know ¿ is the default character when Oracle can't transalte a character.Hence my concern.
Anyone have any ideas or comments as to why this happened? I know ™ isn't a transportable character but if 8i and 9i charsets are compatible why can the exp/imp not translate the char?
-
Originally posted by akhadar
Oracle takes default characterset as WE8ISO8859P1 for 8i and WE8MSWIN1252 for 9i during their database creation.
Not quite. Not even close!
Oracle will check your OS regional settings and decide which character set is appropriate for you by default.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
On a Windows server any idea what regional settings it checks?
-
control panel -> regional settings -> (location and/or language settings)
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Both have regional settings of English (UK) in the Windows OS. Which brings me back to my post which may have been missed:
Originally posted by JMac
We have a Trademark symbol ™ in our 8i database. I did an export and imported it into a 9i database. It appears in the 9i database as ¿. I know ¿ is the default character when Oracle can't transalte a character.Hence my concern.
Anyone have any ideas or comments as to why this happened? I know ™ isn't a transportable character but if 8i and 9i charsets are compatible why can the exp/imp not translate the char?
I'm just confused why 1 symbol in the 8i DB wasn't imported correctly into the 9i DB when both have apparently compatible character sets?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|