exported account list cvs file doesn't show properly in MS Excel

[adrianmak]

OS: Windows XP SP2
sugar ver: 4.5.0f build 1202

Some of my inputted account data has asian characters. All asian characters show correctly in the sugar web application.
When I exported my account list to a cvs (ie sugarcrm only support cvs exporting by default without any add-on modules) and then open in MS Excel, all asian characters can't display properly, all asian characters shown in rubblish characters.

Howver It is wired that I the asian characters in the cvs file show correctly opened by notepad.

Anybody know what's the problem ?

[kpit]

First check your export settings in SugarCRM to make sure you are exporting to a character set that is supported by Excel. Check for language packs and character sets.

[adrianmak]

First check your export settings in SugarCRM to make sure you are exporting to a character set that is supported by Excel. Check for language packs and character sets.

I'm sure that characters set are set properly. I guess this is a problem on exporting cvs file and this only error with asian characters contained and maybe some european character set has problem too. I cannot sure.

Why did I say that because I took a seacrh on the Internet and some some php developer has the same problem when exporting data to a text file (with asian characters) and opend in MS Excel. The solution is it is required to write a three byte data as a header before the real data.

The three byte are,
$utf8_header = "\xEF\xBB\xBF";

I guess in the exporting cvs code has missing this part.