Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ketansoneji
Starting Member
4 Posts |
 Posted - 2010-10-07 : 01:10:50
|
| 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 booksIt 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?Any help is appreciated.Thanks |
|
|
ketansoneji
Starting Member
4 Posts |
Posted - 2010-10-07 : 06:19:00
|
| 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. |
 |
|
|
|
|
|
Import non-english data from Excel into MS SQL