I18N in for xml

This section discusses extending the for xml clause to handle non-ASCII data.

You can specify Unicode columns and string columns containing non-ASCII characters in the select_list of the for xml clause.

The default datatype in the returns clause is text.

The resulting XML document is generated internally as a Unicode string and converted, if necessary, to the datatype of the returns clause.

For detailed documentation of this clause, see “for xml clause”.