Export Format Options

Set export format options for the XML format, column delimiters, and encoding.

Table 1. Export Format preferences: General
Property	Description
Add XML Header Automatically	Insert the XML header string automatically at the beginning of each XML file.
XML Header	Enter the header string to be inserted at the beginning of the XML file, for example, `<?xml version="1.0" encoding="UTF-8"?>`.
Add XML Root Tag Automatically	Include the contents of the SQL result enclosed in a root tag you specify in the Root Tag field.
Root Tag	Enter the XML root tag to wrap the SQL results with, for example, `resultsets`. Do not include angle brackets.

Table 2. Export Format preferences: Default column delimiter
Property	Description
Output Format	Column Aligned — use the same-width font to display the result, and align each column, fill spaces between columns (default) Comma Separated — use comma to separate columns Tab Delimited — use tab to separate columns User-defined — use user-defined string to separate columns The delimiter is displayed for each menu selection in the Delimiter field.

Table 3. Export Format preferences: Default output encoding
Property	Description
Default Output Encoding	cp1252 — Microsoft Windows US (ANSI). This is the default selection. ISO-8859-1 — ISO 8859-1 Latin 1. US-ASCII — US ASCII, with 8-bit data, ISO 646. UTF-16 — Unicode UTF-16. UTF-16BE — Unicode UTF-16, big endian. UTF-16LE — Unicode UTF-16, little endian. UTF-8 — Unicode UTF-8.