Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with using XmlAdapter
Message
 
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01016566
Message ID:
01016593
Views:
19
This message has been marked as the solution to the initial question of the thread.
>It is very small. I will zip it and email it to you right now.
>
>Thank you for your help.

Hi Dmitry,

There're 3 extra bytes (0xEFBBBF) at the beginning of the XML string. They're called a byte order mark (BOM), part of the unicode standard. See http://www.unicode.org/unicode/faq/utf_bom.html#BOM for details. The bytes 0xEFBBBF denote the BOM in UTF-8. I don't know why XmlAdapter recognizes BOM in the file but not in the string. The workaround is easy.
oXml = CREATEOBJECT("XMLAdapter")
*IF lcXml = CHR(0xEF) + CHR(0xBB) + CHR(0xBF)
IF lcXml = 0hEFBBBF   && VFP9
  oXml.LoadXML( SUBSTR(lcXml,4))
ELSE
  oXml.LoadXML( lcXml)
ENDIF
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform