Oracle Database Discussions

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!

Character set conversion from US7ASCII to WE8ISO8859P15

327051May 25 2007 — edited May 25 2007

We have a database (a) on UNIX Solaris that has:
NLS_CHARACTERSET US7ASCII
NLS_NCHAR_CHARACTERSET US7ASCII

We have a database (b) on Windows 2003 Enterprise that has:
NLS_CHARACTERSET WE8ISO8859P15
NLS_NCHAR_CHARACTERSET UTF8

I have a link from database b to database a.
I try to do a simple insert into a table in b selecting from a. The special characters in database b are not updated properly. I tried without setting any NLS_LANG parameter and setting NLS_LANG to US7ASCII.
I tried exporting-importing and it did not work.

Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2007

Added on May 25 2007

#general-database-discussions

4 comments

1,060 views