DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Default Character sets on Windows

Hybrid View

  1. 11-23-2004, 01:40 PM #1
    JMac
    JMac is offline Red Boy of Differdange
    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".
    Reply With Quote Reply With Quote
  2. 11-23-2004, 03:41 PM #2
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    I think DB1 is probably Oracle 8i db, whereas DB2 might be Oracle 9i db
    Reply With Quote Reply With Quote
  3. 11-24-2004, 01:03 AM #3
    akhadar
    akhadar is offline Advisor
    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.
    Reply With Quote Reply With Quote
  4. 11-24-2004, 05:50 AM #4
    JMac
    JMac is offline Red Boy of Differdange
    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?
    Reply With Quote Reply With Quote
  5. 11-24-2004, 06:07 AM #5
    akhadar
    akhadar is offline Advisor
    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 06:10 AM.
    Reply With Quote Reply With Quote
  6. 11-24-2004, 07:44 AM #6
    JMac
    JMac is offline Red Boy of Differdange
    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?
    Reply With Quote Reply With Quote
  7. 11-24-2004, 07:45 AM #7
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  8. 11-24-2004, 07:47 AM #8
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    On a Windows server any idea what regional settings it checks?
    Reply With Quote Reply With Quote
  9. 11-24-2004, 08:00 AM #9
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  10. 11-24-2004, 09:24 AM #10
    JMac
    JMac is offline Red Boy of Differdange
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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