Unanswered: Cannot import non-English data in MS SQL
I have an Excel file containing data in English and some in Korean text.
I want to import this to a table in MS SQL.
I created a new DB with collation korean_wansung_ci_as and created the table first with normal varchar datatype, but on import the Korean text shows up as question mark characters (???). Can anyone suggest what I should do ?
If I do an import in another MS SQL DB not using the specific collation the DTS wizard loads the korean data column as nvarchar (I guess it uses unicode) and is visible.
I want to load the data in the native format but it doesn't work even though I use the right collation. Any idea what I am missing ?