i having problem in oracle 9i dataBase------
i want to convert my oracle data to sql 2000.....but i cant convert
the hindi data from oracle to sql 2000...
means......
i having table in oracle9i...
CREATE TABLE SC_CODE (
GRANT_NO VARCHAR2 (3),
H_CODE VARCHAR2 (13),
FIN_YEAR VARCHAR2 (8),
NAME1_HIN NVARCHAR2 (130),
NAME2_HIN NVARCHAR2 (130),
NAME3_HIN NVARCHAR2 (130),
NAME4_HIN NVARCHAR2 (130),
NAME5_HIN NVARCHAR2 (130),
PRIMARY KEY ( GRANT_NO, H_CODE, FIN_YEAR ))
an having data like----------------------->
04 4059600510101 ¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿
¿¿¿¿¿¿¿(50¿¿¿¿¿0¿¿0¿0)
1
0
04 4059600510102 ¿¿¿¿¿¿¿¿¿ ¿¿¿¿¿ ¿¿¿¿ ¿¿ ¿¿¿¿¿
¿¿¿¿¿¿¿ ¿¿
¿¿¿¿¿¿
0
0
04 4059600510300 TEHSILON KE
AVASIYE
66667
0
0
5965
06 2029000010400 ¿¿¿¿¿¿ ¿¿¿¿¿¿ ¿¿¿¿¿¿¿¿ (¿¿¿0 ¿¿0
07 ¿¿
¿¿¿¿¿¿¿¿¿¿¿¿)
0
2390
these symbol show ¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿----->Datain oracle in Hindi.
my task is to covert the whole ¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿ into hindi as it.
after convertion i saw it never changed it into hindi...it look like
same as in oracle side
i having no problem if i used my front end to insert data into
oracledata base....i having both option hindi and english...
bt when i go throudh my database i never seen the my data in hindi it
look like ¿¿¿¿¿¿ ¿¿¿¿¿¿¿ ¿¿.
what i did for it......(but never suceed...)
The database character set: use AL32UTF8. You can theoretically use
IN8ISCII, which would give you space savings, but as both Java and
Windows support Hindi (actually: the Devanagari script) through
Unicode, you should use Unicode. This way your database will be
prepared for other languages, including other Indian and South Asian
languages.
1.Have 0racle 9i on windows 2000 enterpiseEdition 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;
.................................................. .............>
if you have some solution about tha plz mail me the solution.....
wait for reply---------------------->
al**********@gmail.com al***********@yahoo.co.in