NLS Warning

abc123 · Post by **abc123** » Thu Aug 20, 2009 2:29 pm

I searched through the forum but could not find an answer.

I get the warning:

main_program: The NLS character map <ASCL_MS1252> specified may not be compatible with the character set specified by NLS_LANG;
you may get unexpected results from your database.

My settings are:

1)Character set specified by NLS_LANG: American_America.WE8ISO8859P1

2)Oracle Database NLS_LANGUAGE value: AMERICAN
in NLS_DATABASE_PARAMETERS and NLS_SESSION_PARAMETERS

3)On the target Oracle stage:
Select category to set map for: NCHAR/NVARCHAR2
Map name for 'NCHAR/NVARCHAR2': Project deault (ASCL_MS1252)

chulett · Post by **chulett** » Thu Aug 20, 2009 2:54 pm

So, are you really dealing with NCHAR / NVARCHAR2 data? What is your source?

abc123 · Post by **abc123** » Thu Aug 20, 2009 3:58 pm

No I am not. My source datatypes are regular data types such as Varchar2, Decimal, Bigint etc. I should probably select "Other Types".

dsuser_cai · Post by **dsuser_cai** » Thu Aug 20, 2009 4:27 pm

Check the character set in your data base side.

use:

select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

also check your DS Director log. Especially the second log which has the environmental settings: Check the NLS.

abc123 · Post by **abc123** » Fri Aug 21, 2009 11:55 am

It is:
WE8ISO8859P1

What's interesting is, it happens in one environment but doesn't happen in another. I thoroughly checked both environments and the settings look exactly the same.