Can you tell me if the same happens to you when you specify nls_lang in 9i release 2, or is it just me ?
----- Original Message ----- To: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 02:17 > Thanks anyway > merry xmas > > ----- Original Message ----- > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, December 23, 2003 22:38 > Subject: RE: exam > > > sorry ... no idea about this issue, you need to talk to Oracle. > > Raj > -------------------------------------------------------------------------- -- > ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 23, 2003 9:50 AM > To: Jamadagni, Rajendra > Subject: Re: exam > > > Hello Mr Jamadagni , sorry to trouble you but I have tried asking a question > in [EMAIL PROTECTED] several times and no-one seems to answer. Can you > please help me out. I am not even sure whether I am doing something wrong > or thats how things are supposed to be when specifying nls_lang, but I was > curious so here goes : > > 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. > > Have a merry xmas and a happy new year :) > > > ----- Original Message ----- > From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, October 01, 2003 21:09 > Subject: RE: exam > > > > Congratulations ... so what was your "Hit ratio" ... > > > > Raj > > -----Original Message----- > > > > List , thanks to you all I passed my oracle 9i performance tuning exam > today > > with good marks. > > Thank you > > > > -- 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).