NLS Characterset

[gstork]

We are running an Oracle 10g database using the WE8ISO8895P1 NLS Characterset.

We have an application server which communicates with the database using an Oracle 10g client. The NLS setting in application server is WE8MSWIN1252.



I have the following questions:



a) Which NLS Characterset will my database use when the application connects to the database? In other words which NLS characterset takes precedence, the database or the one in application server?

b) Because the application server (client) character set is different that database characterset, will it corrupt the binary values in the database?

c) How can I find if the binary values that are stored in the database are right and not corrupted?



I need detailed answers. Can you guys help?

[RayaguruSD]

SQL> select * from nls_database_parameters;


PARAMETER VALUE
------------------------- -------------------------

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_ISO_CURRENCY AMERICA
NLS_CHARACTERSET WE8MSWIN1252
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN

[dbasan]

b) You can set the database and apllication compatible to Character set,National character set.

If its other than the required parameters which may not be compatible to your application, you may not see the right output.