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, [EMAIL PROTECTED] 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: <[EMAIL PROTECTED] > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
