Microsoft Excel 2003 + UTF-8 issues

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Re: Attention: European C/C++/C#/Java Programmers-Call for Input
    ... For any language using a Latin ... Look at existing tools and source code that supports UTF-8, and see how it can make your work easier and give a result that users might actually be able to *use*. ... But you'll find something that does a reasonable job and *will* work perfectly for most programmers who stick to ASCII identifiers. ... A related problem is if you are making identifiers case-insensitive - it's hard to figure out cases for non-ASCII characters. ...
    (comp.arch.embedded)
  • =?utf-8?B?UmU6IFN0cmluZyAiw6LigqzihKIiIHRyYW5zbGF0ZWQgdG8gYXBvc3Ryb3BoZS4gV2h5Pw==?=
    ... it works), though it seems to use mostly just Ascii characters, representing ... but the author is not making the best possible use of UTF-8. ... They don't map it to ASCII apostrophe, ... Latin 1 encoding. ...
    (alt.html)
  • Solution to Spanish Accent Problem
    ... The iso-8859-1 encoding will solve your problem. ... Reading a text file with spanish accents ... UTF-8 is perfectly capable of encoding all Unicode characters. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Special Characters in Query String
    ... I've had numerous problems with utf-8, ... in common characters in spanish not geting displayed. ... > available for encoding of characters. ... > If you can display your characters with ISO-8859-1, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DBD::ODBC and character sets
    ... you have and accept UTF-8 encoded data does mean you need to "use ... encoding" but if your script is encoded in xxx you need "use encoding ... Perl sees the left-hand side of eq as a string literal containg sixcharacters encoded as ISO-8859-1 ...
    (perl.dbi.users)