Hello,
We have Production server running on Oracle 12C (12.1.0.2) the Database character set is AMERICAN_AMERICA.WE8ISO8859P1 and National character set is AL16UTF16,
we have installed oracle client 12.1.0.2 on another windows 2008 R2 machine to access db, the windows machine ACP is 1252 and OEMCP is 437, the NLS_LANG setting is AMERICANW_AMERICA.E8MSWIN1252 in the registry, so when we login to DB using sqlplus in dos command windows, the session NLS_SORT=BINARY_CI and NLS_COMP=LINGUISTIC, we need(expect) the setting is NLS_SORT=BINARY and NLS_COMP=BINARY, no need run alter session ...to change them.
so we tried to change NLS_LANG in registry and DOS environment, but none of them works.
we need(expect) the setting is NLS_SORT=BINARY and NLS_COMP=BINARY after login to DB (we don't want to change code to add alter session... or create nlssort index)
We tested below.(both use sqlplus.exe to login)
1. we set NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 in registry and DOS windows or both( same character set as DB), it not work. (NLS_SORT and NLS_COMP no change).
2. we changed code page by chcp to 28591 and set NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1, but it still got same value(not BINARY).
Pls help to how to achieve this without modify DB server side?
If DB and client use same character then it should auto set both parameters as BINARY, correct? Thanks in advance!