cancel
Showing results for 
Search instead for 
Did you mean: 

NLS_lang Parameter Differs

Srinivasjai
Occasional Visitor

NLS_lang Parameter Differs

Hi,

When am query on server side the nls_lang is set to nls_language='american' but it differs in TOAD='United Kingdom'
The O/p as follows

1)SQL> select userenv('LANG') from dual;

USERENV('LANG')
----------------------------------------------------
US
2)SQL> select distinct language from fnd_lookup_values;
LANGUAGE
------------------------------
US
3)SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

But when am trying these Commands through TOAD.
1)select userenv('LANG') from dual;
USERENV('LANG')
--------------------------------
GB
2)SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
----------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY UNITED KINGDOM
NLS_CURRENCY £
NLS_ISO_CURRENCY UNITED KINGDOM

Please can anyone help on this

~Srinivas
1 REPLY
Volker Borowski
Honored Contributor

Re: NLS_lang Parameter Differs

When you run Toad in Windows, it is most likely, that it derives the locale either from the Windows regional Settings
(i.E. setting a german Keyboard and a german
dateformat on a English Windows Server makes
runInstaller present german text !)

or it is explicitly set environment on the client machine. Check by starting CMD.EXE and
execute
SET

to validate the environment on the client side. Check the client for the regional settings in the Windows Control Panel.

Volker