NLS_LANG database and client setting

[carl]

Hey all -

I just installed Oracle Client 10g and I get the popup telling me the character sets are different.

The server is using AL32UTF8 and my client/system is using WE8MSWIN1252.

I was reading in the Oracle Globalization Guide on 3-7 and 3-8 the section that is titled "Should the NLS_LANG Setting Match the Database Character Set?"

After reading that it looks like I can safely just tick the checkbox on the dialog and ignore the message --- is this correct?

Thanks for your help.

 

[Marco Kalter]

That is indeed correct. The only restriction is that you cannot use Unicode characters beyond WE8MSWIN1252 (e.g. Japanese characters) in your SQL and PL/SQL code.