SQL output=xml Does Not Consume Entities - Caveat

In version 7 and later, Vortex <sql output=xml> (here) no longer converts HTML entities in the data to characters before HTML-escaping the output (for XML). This allows the XML output to represent the same data as the source - even if the latter contains entities - properly and consistently escaped. For example, the SQL column Text with data "Mike & &quot;Ike"" would be output as "<Text>Mike &amp; &amp;quot;Ike&quot;</Text>" - the entities are escaped to preserve them, even invalid ones. This behavior change is rolled back if <vxcp compatibilityversion> is set to 6.

Copyright © Thunderstone Software     Last updated: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.