Problem reading XML-data (ä,ê etc)

Hello to you al,

I read data from an XMl document but I have problems in reading the ë,â etc.
For instance: In the XML document there is
<Country>België</Country>
I know this because I opened the XML-document.

When I do a Trace( XMLData("xmldoc") ) the answer is: België
It changes Hülcke into something like HÃ&frac14;lcke.

I looked in the help at XMLData but there is nothing about transforming accents?
I think it has something to do with the character set used but I don't know how to solve it.
What happened and how can I get the right answer.

Regards and thanks in advance,

Frans



Edited 1 time(s). Last edit at 03/08/2009 11:44PM by Frans.

Hello to you al,


I think I solved it.
I used UTF8ToString(XMLData("xmldoc") ")

It works but I don't know if it can produce other problems because I think it is a sort of translation table. So it is possible that it now produces wrong answers for other combinations of characters.
Anybody any idea?

Regards and thanks in advance.

Frans

Hi,

Please bear in mind that XML is not necessarily encoded as UTF8... It could be UTF16, ANSI or otehr ISO encodings. The encoding describes the byte-order and character map of the content, not the content itself.

What you want to do is encode reserved (ampersand, slash, greater than, smaller than, ...) or other special characters... The commands to use for making the text content XML compliant are:
TextToXML() and XMLToText()

Cheers,

Peter