Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export in one character set and import in different

430060Sep 27 2004 — edited Apr 2 2007

Hi,

Hi,

I have one database where NLS_LANG is set to American_America.WE8ISO8859P1, If I export and import it in different database where American_America.UTF8, it throws error for some rows..

Please note that problem comes only with those rows where whole length is cooupied.. e.g. IF I have char(10), and all 10 bytes are occupied, then I get this problem. But If I have at least 1 bvyte free, then import is successful.

I can't change schema definition to increase the column length because of application constraints.

Is there any workaround of this problem.

Thanks

Puneet

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2007

Added on Sep 27 2004

#database-key-features, #globalization-support

10 comments

24,873 views