Why do Excel and IE8 give an error when viewing XML with an ë in it?

Question

Maybe this is an encoding issue? I can't imagine that you have to replace every non standard character.

Example XML:

<?xml version="1.0" encoding="utf-8"?>
<client>
      <achternaam>Erriëns</achternaam>                                 
</client>

With or without the first line doesn't matter.

Error in IE8:

The XML page cannot be displayed 
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. 
--------------------------------------------------------------------------------
An invalid character was found in text content. Error processing resource 'file:///C:/Users/******/SO.xml'. Line ...

      <achternaam>Erri

Excel doesn't like the ë either.

Answer 1

That's because you haven't actually saved the file as UTF-8. The header says UTF-8, but the actual encoding of the file is something different.

In notepad choose the Save As option, then select UTF-8 as encoding.