Oracle Database Discussions

Hi All,

We are using oracle 9i.
We are storing some russian data in a database, the characterset we are using is UTF8. The NLS_LANG value we are using is RUSSIAN_CIS.CL8ISO8859P5.
Databse properties for the database is as under
NLS_LANGUAGE --> AMERICAN
NLS_TERRITORY --> AMERICA
NLS_CURRENCY --> $
NLS_ISO_CURRENCY --> AMERICA
NLS_NUMERIC_CHARACTERS --> .,
NLS_CHARACTERSET --> UTF8
NLS_CALENDAR -->GREGORIAN
NLS_DATE_FORMAT --> YYYY-MM-DD:HH24:MI:SS
NLS_DATE_LANGUAGE --> AMERICAN
NLS_SORT --> BINARY
NLS_TIME_FORMAT --> HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT --> DD-MON-RR HH.MI.SSXFFAM
NLS_TIME_TZ_FORMAT --> HH.MI.SSXFF AM TZR
NLS_COMP --> BINARY
NLS_LENGTH_SEMANTICS -->BYTE
NLS_NCHAR_CHARACTERSET --> AL16UTF16

we want to display the same russian data in SQL*PLUS (which we are using as a client). For that we tried the above mentioned NLS_LANG parameter and we also tried
NLS_LANG = RUSSIAN_CIS.CL8MSWIN1251. Both the NLS_LANG parameter is working fine.

Now i want to store some hindi data into the database, and same we want to display in SQL*PLUS. What i read is that by defining the characterset UTF8 it is possible
so i just tried RUSSIAN_RUSSIA.UTF8 as a NLS_LANG value, when i supply this value in windows registry(HKEY_LOCAL_MACHINE-->SOFTWARE-->ORACLE-->HOME0-->NLS_LANG) then it takes the value, but when i tried to connect the
database then oracle throws an error
INVALID VALUE SPECIFIED FOR NLS PARAMETER.

I also tried to store and view only hindi data in SQL*PLUS by changing the two registry values as HKEY_LOCAL_MACHINE-->SOFTWARE-->ORACLE-->HOME0-->NLS_LANG = HINDI_INDIA.IN8ISCII and SQLPLUS_FONT_CHARSET= HINDI. Then also i'm unable to view hindi data from tables.


Now what I want is that, to store and view hindi as well as russian data in a database and view the same in SQL*PLUS. Please help me out if thr is some solution for the same.

Thanks & Regards
Amit Pandey