T
Tapshil
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
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