List, I did a reinstall and got the french language support back when I
specified the languages during the reinstall.
Thanks
Merry xmas and happy new year :)
----- Original Message -----
To: <ORACLE-L_at_fatcity.com>
Sent: Thursday, December 25, 2003 06:39
> 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).
Received on Thu Dec 25 2003 - 00:04:25 CST
