Microsoft Excel 2003 + UTF-8 issues
 

Hi,

In our project We are using Oracle DB and it has UTF-8 character
encoding. So data could be in any language. In our application we are
exporting data
to Microsoft Excel 2003 with following content type and encoding.

"application/ms-excel;charset=UTF-8"

But the MS-Excel doesn't understand UTF-8 charset. On the contrary if we
export data directly to Microsoft Word 2003 with UTF-8 it displays all the
characters correctly. I tried to search this forum and on the internet but I
have not (and so many other people) got answer yet why why why Micrsoft
Excel doesn't understand UTF-8.

Hence I was experimenting with different charsets and I found if I use
charset="UNICODE", all the characters will be displayed (in different
languages) correctly. I have not found reason for it.

So if anybody has any explanation for it then please reply.

Thanks & regards,
Tapshil