Participant

Question

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

Forum|Forum|19 years ago
February 5, 2007
2 replies
1064 views

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

Database access

This topic has been closed for replies.

Inspiring

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

Participating Frequently

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