Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: List please help

Re: List please help

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 24 Dec 2003 22:14:24 -0800
Message-ID: <F001.005DB082.20031224221424@fatcity.com>


Could be that no one has an answer.

When I set NLS_LANG=French_France.US7ASCII, everything is in English, which is what I would expect with US7ASCII.

Are you sure that was your previous setting?

Jared

On Wed, 2003-12-24 at 17:14, bulbultyagi_at_now-india.net.in wrote:
> List , sorry to keep troubling you all but even if you are not interested in
> helping could someone just let me know if this happens by default in 9i
> release 2 or am I doing something wrong.
>
> I am using 9.2.0.1.0 enterprise edition on windows.
> Earlier when I use to specify nls_lang=French_France.US7ASCII in 9i release
> 1
> I would get the following messages in French
>
> c:> sqlplus
> Entrez le nom utilisateur :
>
>
>
> But now when I specify nls_lang=French_France.US7ASCII , sqlplus sticks to
> english
> c:> sqlplus
> Enter user-name:
>
> Any ideas ?
>
> I tried out the following but to no avail :
> 1. I specified ora_nls33 to point to
> D:\OracleXP\Ora92\ocommon\nls\ADMIN\DATA where D:\OracleXP\Ora92\ is my
> %oracle_home%
>
> 2. I set nls_lang=French_France.US7ASCII , log in as a user, checked
> NLS_SESSION_PARAMETERS. It shows that NLS_LANGUAGE is
> FRENCH and NLS_TERRITORY is FRANCE. When I select from a column containing
> dates , the months are in French. sysdate also gives the month in french
>
> 3. Same behaviour with nls_lang=French_France.WE8MSWIN1252 and
> nls_lang=nls_lang=French_France.UTF8 (although this is an incorrect
> specification since there are no utf8 windows clients )
>
> 4. Similarly when I specify nls_lang=ENGLISH_INDIA.WE8MSWIN1252 my queries
> pick up the correct local currency symbol. and nls_language and
> nls_territory values in nls_session_parameters are correct.
>
> 5. Alert log doesn't show any errors.
>
> My database character set is AL32UTF8 , did not specify an nchar
> characterset while creating the database.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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 Dec 25 2003 - 00:14:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US