I have two database.
1. Normal stardard WE8EBCDIC37 character set database
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.
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.
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.
Click Here to Expand Forum to Full Width