For strings that cannot be used in XML reading

Question

When loading an XML file, strings such as " " and "&" cause an error.
Are there any strings that cannot be used when loading XML?
Also, other than the above, what other strings will cause an error?

The entity name must immediately follow the '&' in the entity reference.

Answer

The XML connector conforms to W3C definition, which defines the XML specification.

Please refer to the following page for W3C information and check if you are using XML that conforms to the W3C definition.

　W3C XML 1.0 Specification
　https://www.w3.org/TR/xml/

For example, if you read the following XML, "The entity name must immediately follow the '&' in the entity reference.” error occurs.

　--- 
　<root>
　 <data>
　 <key>12&3</key>
　 </data>
　</root>
　---

On the other hand, if CDATA is used as shown below, it is not illegal as XML and can be read by the XML adapter even if "&" is included in the XML.

　--- 
　<root>
　 <data>
　 <key><! [CDATA[12&3]]></key>
　 </data>
　</root>
　---