Default Character sets on Windows
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Default Character sets on Windows

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    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".

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I think DB1 is probably Oracle 8i db, whereas DB2 might be Oracle 9i db

  3. #3
    Join Date
    May 2001
    Posts
    736
    Exactly this is because of different versions of oracle and also the import works because WE8MSWIN1252 is a superset of WE8ISO8859P1.

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Correct about the versions chaps!
    Can you elaborate?

    Should the import/export function ok? Or will there be possible character conversion problems?

  5. #5
    Join Date
    May 2001
    Posts
    736
    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 05:10 AM.

  6. #6
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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?

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  8. #8
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    On a Windows server any idea what regional settings it checks?

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  10. #10
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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
  •  



Click Here to Expand Forum to Full Width