Problem in reading .csv file with unicode characters

[James Wong]

Hi everybody,

I got problem in reading .csv file with unicode characters. The .csv file
is generated by a self-developed application and Chinese characters is
included in that file. I open it by Excel 2003 and found all Chinese
characters are mis-encoding. Of course, if I change the encoding of .csv
file to BIG5 (or ASCII), it is ok. However, I need to keep unicode encoding
to fit my application requirement. Does anybody know the solution on my
case? I suppose Excel 2003 supports unicode. Am I right?

Thanks for your attention and kindly advice!

Regards,
James Wong

 

[sunwukong]

James I am having similar problems but with excel 2000. I found that using
the hex code for the characters I was able to write the proper character to a
cell and get it to display properly by using the simsun font or the
songuni-p1p2 font. You may have to d/load some additional fonts to get the
characters to show. I can not get the 5digit hex values of the surrogate
pairs to display in excel 2000 under win 2000, but if I export the file to a
text file (that is basicaly what a .csv file is), the characters show fine in
notepad. What version (language) of windows and excel are you using? There
may be a problem if the file was created in a different language version of
either if the file is loaded or edited on another differently set up system.