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?
SQL> select * from nls_database_parameters;
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.
"What is past is PROLOGUE"
Click Here to Expand Forum to Full Width