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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2008-01-09 : 02:47:41
|
| Hi AllI have loaded some data to the application using flat fileswhich has non english chars.all the columns in the database are NVARCHAR type.but in db and in application UI, the non english chars are being diplayed as junk chars. ???121The application supports UTF-8 formatis there any setting at db level to be modified to display the non english char set as is.Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-09 : 02:56:16
|
| are you sure the data is being loaded properly? How are you loading the data? I suspect you have loaded junk data into the db.-ec |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:14:02
|
| Did you load data with leading N like N'xxxx'? |
|
|
|
|
|
|
Non english chars are being shown as junk chars