Data export and import from different character sets

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

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

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.