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