October 6, 2010 at 9:04 am
Currently I have an excel sheet which contains data in english, french and hindi.
I want to import the data into a new table in MS SQL database. I used the 'Import Data' utility to import the data but it seems that it messed up the french and hindi data in the target database. The columns in the target SQL table are of data type nvarchar.
I tried verifying by executing the following query on the target table after importing the data:
select nchar(value) from books
It gave me the following error:
Conversion failed when converting the nvarchar value 'स्थिति' to data type int.
It does display the correct language text(in hindi) in the error but I am worried about the error. I am not sure if my method of verification is incorrect. If so, is there any other alternate way to verify if my data has indeed stored correctly. In case my data is stored incorrectly then is there any other mechanism for importing data from excel sheet into ms sql database?
I have attached the xls file for reference.
Any help is appreciated.
Thanks
October 7, 2010 at 4:20 am
Oops..I got it..my method of verification was incorrect...the data that was imported was correct.
I created a jsp (with page encoding set to UTF-8) and printed out the data. It was perfect.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply