Dear list, Question in Brief:
1. 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. 2. 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).