Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Eclipse Data Tools Platform Guide
Previous Page Home Next Page

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.

  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire