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

Thread: Data export and import from different character sets

  1. #1
    Join Date
    May 2001
    Location
    Pune
    Posts
    32
    Hi Friends,

    I have two database.
    1. Normal stardard WE8EBCDIC37 character set database
    and
    2. TH8TISEBCDIC

    If I want to export my all tables from WE8EBCDIC37 to TH8TISEBCDIC What I should DO?

    Is there any options than export & import?
    Can somebody pleasea give me detail information.

    Thanks,

    Rajendra

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    That should be fine. Language translation is automatic.

    The only possible problem I can see is if you try a translation to a character set where there is no translation. I'm not sure if it stops the import or if the data imported (that can't be translated) ends up pound signs (####) or something.

    Test it by exp/imp'ing 1 small object.

    -Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    May 2001
    Posts
    736
    U can use the Alter database command to change the Character set after importing your data but still there is no gurantee that u will have all the data as there is chance that u are going to corrupt some of your data.
    so it is strongly advised to have same character set between the two database before using export/import.

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