Export Format Options Preferences

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

Table 1. Export Format Options preferences: General
Field	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 Options preferences: Default column delimiter
Field	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
Delimeter	Displays the delimiter for the output format.

Table 3. Export Format Options preferences: Default output encoding
Property	Description
Default Output Encoding	cp1252 (default) — Microsoft Windows US (ANSI). 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 (default) — Unicode UTF-8.