Hindi Data in SQL Server 2005 database

I am developing a windows application which need to insert data from a MS Excel file which contains a lot of data in two different languages, English and Hindi. I am able to import the English data easily but while importing the Hindi data the its been converted to some English text.

I am using NVARCHAR as datatype for all my fields. Arial Font for English and SHUSHA font for Hindi Language. In Excel the data is correctly shown. But in SSMS and my Applic开发者_运维技巧aton the Hindi data is shown as some english characters.

Kindly help !

NVARCHAR is definitely able to store Hindi Unicode characters. There must be something wrong with your SQL insertion code, i.e maybe you are using a SqlParameter with datatype SqlDbType.VarChar when you are inserting. Posting this code would clarify.