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" <Rajendra.Jamadagni_at_espn.com>
Sent: Wednesday, December 24, 2003 02:17
> Thanks anyway
> merry xmas
>
> ----- Original Message -----
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> To: <bulbultyagi_at_now-india.net.in>
> 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: bulbultyagi_at_now-india.net.in [mailto:bulbultyagi_at_now-india.net.in]
> 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 oracle-l_at_fatcity.com 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" <Rajendra.Jamadagni_at_espn.com>
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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: <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).
Received on Wed Dec 24 2003 - 18:54:25 CST
