Chinese Language Characters

When I import an excel file to SQL that contains Chineses characters they get
distorted and illegible. How do I get SQL to interpret the characters
properly?
Thank you!
Several things need to happen.
You need to have the language pack installed on the PC. It sounds like you
do because you can see them in Excel.
The second thing you need to do is to use the nchar, nvarchar and ntext data
types when you create your tables. These are the national character sets
and allow for other language use.
If that doesn't work, ensure that you are using the appropriate collation
when you create your objects. You can set a collation for an entire
database, a table, or individual columns.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"JuJu" <JuJu@.discussions.microsoft.com> wrote in message
news:E29BAD1F-8790-4D55-9AFA-301034186BB8@.microsoft.com...
> When I import an excel file to SQL that contains Chineses characters they
get
> distorted and illegible. How do I get SQL to interpret the characters
> properly?
> Thank you!