SQLPLUS, NLS and spool to file
Hello !
We have an application server Windows 2016, thru our application we can start sqlplus using cmd. We have our own settings for cmd, among one is NLS_LANG, set to AMERICAN_AMERICA.WE8MSWIN1252
The odd part is that if he starts the sqlplus and just do
spool t1.txt
prompt It is Räining today
spool off
Using one swedish special character, the file is created as a UTF8 file format
If he omits special characters it is saved as ansi format.
I cannot reproduce that on another server, I always get ansi format
unless I change nls_lang to utf8
We have an application server Windows 2016, thru our application we can start sqlplus using cmd. We have our own settings for cmd, among one is NLS_LANG, set to AMERICAN_AMERICA.WE8MSWIN1252
The odd part is that if he starts the sqlplus and just do
spool t1.txt
prompt It is Räining today
spool off
Using one swedish special character, the file is created as a UTF8 file format
If he omits special characters it is saved as ansi format.
I cannot reproduce that on another server, I always get ansi format
unless I change nls_lang to utf8
0