Oracle-L: Oracle 7.3 client and NLS

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Thu, 25 Sep 2003 00:19:40 -0800
Message-ID: <F001.005D0F80.20030925001940@fatcity.com>

Dear list,

Question in Brief:

On 7.3 client even if NLS_LANG in registry is set to
'AMERICAN_AMERICA.US7ASCII', the default NLS_DATE_FORMAT for the
session is set to 'DD-MON-YY'. How come? Shouldn't it be
'DD-MON-RR'? There is no environment variable NLS_LANG nor any
SQL*Plus variable. Yes, I can fix it by setting NLS_DATE_FORMAT explicitly, still I would like to know why.
The client seems to be picking NLS_LANG value from HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE rather than HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 as documented on Metalink. Any ideas why?

Thanks & regards,
Charu

Detailed scenario:

Server: 8.1.7.4
OS: HP-UX 11

Client: 7.3.4
OS : Win NT4 (Connected through Win Terminal Server) Registry entries:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key has a name-value pair: NLS_LANG = "AMERICAN_AMERICA.US7ASCII" HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 key has a name-value pair:
NLS_LANG = "ENGLISH_UNITED KINGDOM.WE8ISO8859P1" When I connect to SQL*Plus on client:

SQL> host echo %NLS_LANG%
%NLS_LANG% This means that no NLS_LANG environment variable is set up.

SQL> @.[%NLS_LANG%].
SP2-0310: unable to open file ".[AMERICAN_AMERICA.US7ASCII]."

How come? Metalink says it should be the registry entry under default home(HOME0) i.e ENGLISH_UNITED KINGDOM.WE8ISO8859P1

SQL> select * from nls_session_parameters;

PARAMETER                      VALUE
------------------------------ -----------------------------------
-----
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-YY -- The other anomaly.
Shouldn't it be DD-MON-YY?
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY

15 rows selected.

When I tried the same through 8i client, I got the documented behaviour i.e. the NLS_LANG was set to the registry entry under default home (HOME0) and the NLS_DATE_FORMAT was 'DD-MON-RR'.

Is this a problem with the 7.3.4 client?

Thanks very much if you have been patient enough to reach here.

Regards,
Charu.

Disclaimer

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

Visit us at http://www.mahindrabt.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Charu Joshi
  INET: joshic_at_mahindrabt.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Sep 25 2003 - 03:19:40 CDT

Oracle 7.3 client and NLS_LANG anomalies