Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing/Retrieving Hindi Characters

72395Jul 11 2006 — edited Jul 11 2006
My aim is to store and retrieve names in Hindi as well as english.
This is what I have tried..

1. select * from nls_database_parameters
It shows me that
NLS_CHARACTERSET US7ASCII
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16

From what I understand with these settings I will not be able to store
Hindi characters etc in CHAR/VARCHAR2 fields but I should be able to do so in
NCHAR or NVARCHAR2 field

2. I created a table
CREATE TABLE TEST_HINDI ( name NVARCHAR2(40));

3. From my client machine ( which is different from the server) - I use
isqlplus to login to this database. For this I use the browser http://IP of
Oracle server:7777/isqlplus

4. I installed Gargi font(uses Unicode) on my client machine to get hindi
charcaters

5. I use charmap to view those hindi characters and then select /copy one of
them

6. Through isqlplus if I give command

insert into test_hindi value ('त');
It gets converted into a statement like
insert into test_hindi values ('#2340;')
and gives error: SP2-0553: Illegal variable name "#2340;')".

6. I check the hex of this character - It is 0924
So I try insert into test_hindi value ('/0924');

The row gets created. But now when I view by select name from test_hindi --
It displays /0924 only

I tried select unistr(name) from test_hindi.. Now it just displays a blank

I don't know what more to try ??

Hope you can help !!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2006
Added on Jul 11 2006
1 comment
4,294 views