How to get Swedish character from application.

Issue : When we execute report query swedish character is not display.

It is getting display correctly from SQLPLUSW,TOAD and SQL DEVLOPER

but not with sqlplus CMD based window.

Solution : To get display of Swedish character  need to set  NLS_LANG envrionment variable.

export NLS_LANG=SWEDISH_SWEDEN.WE8MSWIN1252  --GUI/UNIX
export NLS_LANG=SWEDISH_SWEDEN.WE8PC850----------in WINDOW Dos Promprt

If you dont want date in SWEDISH, then only below setting is sufficent.

export NLS_LANG= AMERICAN_AMERICA.WE8MSWIN1252  for UNIX./GUI
export NLS_LANG= AMERICAN_AMERICA.WE8PC850