Hindi in Oracle 9i
Hi Everyone.
I am using oracle 9i database and using forms 9i . I am trying to store customer name in hindi .I am trying the following:-
1. The prompt of text box should be in hindi.
2. The input text box should be able to accept text in hindi.
3. The data should be stored in oracle db .
4. When I retrive data and print on report it should be in hindi.
I am facing problems in following:-
1. My exiting NLS_CHARACTERSET is WE81508859.. . What should I do it to change to UTF8 ( if I realy need it.)
2. Should I make changes in init.ora or somewhere else.
3. I am using jre 1.4.1.x.
I am using channakay ttf and kruti dev fonts
What I have done yet:-
1.Have 0racle 9i on windows 2000 server and client on same
2. regedit and changed NLS_LANG. Change the value to AMERICAN_AMERICA.UTF8 . For 9idatabse as well as devloper suite.
3. Internet explorer changed the following font Lucida Sans Unicode
4. SELECT * from NLS_DATABASE_PARAMETERS;
5. CREATE TABLE product_descriptions
( product_id NUMBER(6)
, language_id VARCHAR2(3)
, translated_name NVARCHAR2(50)
, translated_description NVARCHAR2(2000)
);
6. select Encoding from the View pulldown window click Unicode (UTF-8).
7 trying store hindi characters in table product_descriptions using isqlplus
But I am not able to do it.
Please help.
Prashant