February 3, 2009 at 5:08 am
I am trying to import a file to a table in my DB. I just right clicked on the Db , went to tasks, and then import data.
i set up the import package to import the data, but any asian data does not show up correctly. it doesnt show as asian symbols, but as a row just little rectangles.
what am i doing wrong in this case?
February 3, 2009 at 5:18 am
Are you using Unicode data types in SQL server ? nchar + nvarchar
February 3, 2009 at 5:59 am
yea, any columns in question are nvarchar
February 3, 2009 at 6:06 am
Update on this:
It seems that when i query teh data using SSMS installed on the server i expirience the problem where i cant see asian charachters, however if i query the data from SSMS installed on my machine, I can see the data!
what system wide settings or SSMS settings could cause this issue?
February 3, 2009 at 6:50 am
In SMS in the Save button there is an arrow click on it and you will see the query save options change it to the version of Chinese, Japanese or Korean you need and the problem will go away. You should also know the database and table collations needs to be the same.
Kind regards,
Gift Peddie
February 3, 2009 at 6:53 am
but from my previous post, i can see this is pc specific. i get the odd charachters from the server the database is located on, but running the same query from my own pc connected to the server via SSMS produces perferctly formatted asian charachters.
February 3, 2009 at 7:00 am
Vista comes with language packs but XP and Win2003 comes with the packs not installed you have to install it, so may be the server the database is located is missing the langauge pack. But this thing is very easy to fix change the query save encoding and adjust the properties of the database.
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply