chinese character displaying as ???? in excel while importing data from sql-server 2000

[kanishkavijay]

Hi everyone,

I am facing a problem while importing sql-server 2000 data in excelshhet .There is some chinese character in database table.
After importing data in excel chinese character looks like ????????.In sql-server this chinese character looks like square field.
I am using UTF-8 .
This is last hope.

vijay k singh Text

[Foxchx]

I was having the same problem with the AIRSQL i couldn't find how to rencode my csv file...

So i resave the csv in xls and then chose the utf-8 thingy and then just changed the extension back to csv.

i was always wondering why i had an xls file in my source code, which was just left there from the previous reencoding, i guess

hope it helps

[Dileep_NR]

Please make sure the data in the database with the chinese character.