Hi Ankur,
 
The NLS_LANG environment variable is used for configuring the Oracle database products. If you mean that you want to set up your copy of Oracle for Russian, you could use:
 
NLS_LANG=RUSSIAN_CIS.<charset>
 
where <charset>== one of the following:
 
CHARACTERSET         CL8ISO8859P5
CHARACTERSET         RU8PC866
CHARACTERSET         RU8BESTA
CHARACTERSET         RU8PC855
CHARACTERSET         CL8MACCYRILLIC
CHARACTERSET         CL8MACCYRILLICS
CHARACTERSET         CL8MSWIN1251
CHARACTERSET         CL8KOI8R 
 
You might also want to consider being a bit forward looking and choosing the Unicode character set:
 
NLS_LANG=RUSSIAN_CIS.UTF8  // Oracle 8x
NLS_LANG=RUSSIAN_CIS.AL32UTF8  // Oracle 9x
 
Note that you need to install your database instance using a matching or compatible encoding before your local setting will work correctly. The instance character encoding is chosen at instance creation time and (more or less) cannot be changed after that.
 
If you really mean in your UNIX environment, the environment variable you mean is "LANG" and you can use the "locale -a" function to find out what Russian locales you have installed. You will need to set up your UNIX environment to display any Russian characters that you retrieve from the database, so you'll probably end up setting both (again, UTF-8 locales in UNIX work nicely with Unicode encoded databases).
 
Hope that helps.
 
Best Regards,
 
Addison

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ankur Mahajan
Sent: Wednesday, August 14, 2002 12:50 AM
To: [EMAIL PROTECTED]
Subject: NLS_LANG for russian characterset in UNIX

Any clue if i want to use RUSSIAN  characterset in UNIX environment, what should i set in .profile for NLS_LANG
like for american english,
it is  NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
 
so what should be the same setting for russian charset ??
 

Regds,
Ankur Mahajan
Asst. Systems Engr.
Tata Consultancy Services
Gurgaon
Ph. 0124-6342944/941/542 Ext. 112/115
9811324429

Reply via email to