# 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

- 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.

Related concepts
SQL Results View
Related tasks
Viewing SQL Results
Related reference
SQL Results View Options Preferences
History Options Preferences
Result Set Viewer Preferences