Storing/Retrieving Hindi Characters
72395Jul 11 2006 — edited Jul 11 2006My 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 !!!