Special Characters in the Request
Because the SQL request is sent as the text of an XML element, and not as CDATA, any special characters must be replaced with their XML-compatible character entities. The following table shows these characters and their proper character entities:
Character | XML character entity |
---|---|
& (ampersand) | & |
< (less-than) | < |
> (greater-than) | > |
' (apostrophe, single quotation mark) | ' |
" (double quotation mark) | " |