XML does not support binary string data, so if you plan on encoding memo fields that contain sub char(32) characters you need to convert those fields to BLOB fields (CAST(val AS W)) so that they are base64 encoded when converted to XML.
CREATE CURSOR temp (val w)
INSERT INTO temp val VALUES (CHR(10) + CHR(15) )
lcXml = ""
? CURSORTOXML("Temp","lcXml")
which produces:
<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
<temp>
<val>Cg8=</val>
</temp>
</VFPData>
+++ Rick ---
>Hi,
>
>I am storing an encrypted string into an XML file. But when I try to load this XML into a cursor I get error "An invalid character was found in text content". The code of loading the XML file is:
>
>XMLTOCURSOR( "MyXmlFile.xml", cCursorName, 512+8192)
>
>
>And this encrypted string is stored in XML using CURSORTOXML(). What do I need to do when storing or loading this stgring to make it work?
>
>TIA