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 & "Ike"" would be
output as "<Text>Mike & &quot;Ike"</Text>" -
the entities are escaped to preserve them, even invalid ones. This
behavior change is rolled back if <vxcp compatibilityversion>
is set to 6.