RE: NLS_LANG for russian characterset in UNIX

From: Addison Phillips [wM] (aphillips@webmethods.com)
Date: Wed Aug 14 2002 - 08:58:07 EDT


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: unicode-bounce@unicode.org [mailto:unicode-bounce@unicode.org]On
Behalf Of Ankur Mahajan
  Sent: Wednesday, August 14, 2002 12:50 AM
  To: unicode@unicode.org
  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



This archive was generated by hypermail 2.1.2 : Wed Aug 14 2002 - 07:11:01 EDT