DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: character set

  1. #1
    Join Date
    Oct 2000
    Posts
    20
    Can you please find out from Oracle step by step procedure to convert a database from simplified Chinese Character to traditional Chinese Character.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ehhhh have you tried it yourself at all huh?

  3. #3
    Join Date
    Oct 2000
    Posts
    20
    I have a DMP file exported from a Simplified Chinese Character Set Oracle DB. But I need Import this DMP file into a Oracle DB with defferece character Set(eg. Tranditional Chinese Character Set). Please tell me whether or not there are some method to do it. Thanks!

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    There is an article on [url]http://www.oracledba.co.uk[/url] to change a character set. Check it out and then check on Metalink to check for relevant info.

  5. #5
    Join Date
    Oct 2000
    Posts
    20
    I don't want to change character set for my DB.The only thing I want to do is import DMP file(exported from Simplified Chinese DB) into another DB with tranditional Chinese character set.

  6. #6
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Multi-Byte Character Sets and Export and Import

    An export file that is produced with a multi-byte character set (for example, Chinese or Japanese) must be imported on a system that has the same character set or where the ratio of the width of the widest character in the import character set to the width of the smallest character in the export character set is 1. If the ratio is not 1, Import cannot translate the character data to the Import character set.

    I never tried before . But I think possible or not , it's depandant on how you input numberic and special chars (like '*=') into the varchar2 column . If the numberic and
    special char are also stored as 2 chars which is same as simplific chinese . Then the conversion is possible .

    I remeber that for Simplific Chinese Env. There are
    two kinds to input the numberic and special char into varchar2
    . One is just use Ascii , which is 1 char , Another is using Simplific Chinese input , which is stored as 2 chars .
    Converison is only possible in the second case .

    Anyway , If anybody has done before , please let me know .






  7. #7
    Join Date
    Oct 2000
    Posts
    20
    Who can tell me what's diference and relation in NLS_LANG,NLS_LANGUAGE,NLS_CHARACTERSET ?

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