XML re-encoding... 1

[Neil Toulouse]

Hi

We have an issue where one of our customers is generating an XML file with the incorrect encoding (ANSI not UTF-8).

Is there a quick and dirty method (in VFP - I know this can be done in Notepad but needs to be in VFP) to re-encode this XML file or do I need to reconstruct it with the correct encoding?

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[Olaf Doschke]

Look up the StrConv() function. Strconv(ansistring,9) does convert to UTF-8. I'd also ask the customer to correct his encoding.

Also look into the first bytes of the xml file. Maybe your customer simply used notepad to make some manual changes and didn't care to choose the correct encoding. And even if they choose UTF-8 in notepad, the first few bytes will then be a BOM (byte order mark) and will not comply to XML parsing, they need to be removed.

Bye, Olaf.

 

[Neil Toulouse]

Cheers Olaf, I will give it a go!



I like work. It fascinates me. I can sit and look at it for hours...

 

[Neil Toulouse]

Thanks Olaf, STRCONV() does the job

I like work. It fascinates me. I can sit and look at it for hours...