My db is AL32UTF8, my apps are WE8MSWIN1252. Can I reconfigure the apps as American_America.AL32UTF8
Our ERP environments have a potential configuration problem(I think).
The were configured like following for the character set:
The database is configured as an AL32UTF8.
SQL> SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
VALUE
----------------------------------------------------------------
AL32UTF8
echo %NLS_LANG%
American_America.AL32UTF8
but our applications are configured as American_America.WE8MSWIN1252 :
echo %NLS_LANG%
American_America.WE8MSWIN1252
grep s_weboh_nlslang %CONTEXT_FILE%
<NLS_LANG oa_var="s_weboh_nlslang">American_America.WE8MSWIN1252</NLS_LANG>
grep s_nlslang %CONTEXT_FILE%
<NLS_LANG oa_var="s_tools_nlslang">American_America.WE8MSWIN1252</NLS_LANG>