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!

Oracle Export charset concern

user12243721Feb 1 2011 — edited Feb 1 2011

Hi everyone,

Running Oracle 9i version 9.2.6.0 running on windows server 2003

I have run an export which completed sucessfully WITH warnings.
I figure I am getting this message due to the following line at the top of teh export log

"Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)"

What is causing me concern is that when I check the the following table v$NLS_PARAMETERS it clearly shows NLS_CHARACTERSET = WE8ISO8859P1 and not WE8MSWIN1252.
I have no idea where it is getting this or why it is using it for the export.

Should I be foucing on setting NLS-LANGi in environment variable at the OS user level, it doesn't seem to have one set. Or should I be foucesd on the fact Oracle seems to be showing two different character sets. Bascially I am stumped.

So now I don't know how to resolve this issue, any advice would be greatly appreciated.

Thanks guys

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2011

Added on Feb 1 2011

#general-database-discussions

4 comments

3,555 views