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:
01016605
Views:
27
>>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
>>
>
>Sergey,
>
>Thank you for the explanation and work around. I did see those 3 bytes but didn't know what it was all about. Now I have two work- arounds, either copy to file and get it from the file or using SUBSTR() as you suggested.
>
>Thank you for your help.

You're welcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform