- Select .
Click the Data Format tab and complete the fields.
Option Description Display dashes between bytes for binary data values
When selected, a dash appears between each byte of the value for ease of reading, for example, ‘63-B1-A3-62’.
The default is selected.
Write Byte Order Mark [BOM] to CLOB output files
Select this option to add a Byte Order Mark at the start of each CLOB file.
The default is cleared.
Display BigInt and Decimal(16)+ values as strings
When checked, large numeric values are stored as strings for Excel compatibility.
When cleared, values with more than 15 digits are rounded when saved to Excel.
The default is cleared.
Display this string for Null data values
Enter the string to be displayed in place of Null data fields in the reports and imported/exported files.
The default is “?”.
Display dates in this format The drop-down list contains predefined options to select. The characters d, m, and y to signify the day, month and year components can be added to the list. It also accepts /, -, ',' and space characters can be added as delimiters. Day formats are specified by repeating characters as follows:
- d – Day number without leading zero
- dd – Day number with leading zero
- ddd – Day name abbreviated
- dddd – Day name in full
Month formats are specified by repeating characters as follows:
- m – Month number without leading zero
- mm – Month number with leading zero
- mmm – Month name abbreviated
- mmmm – Month name in full
Year formats are specified by repeating characters as follows:
- yy – Year, represented with 2 digits
- yyyy – Year, represented with 4 digits
The dash, slash, comma, period and space characters are insertion characters.
dddd, dd mmm yyyy displays Monday, 07 Mar 2008
Whereas d-mm displays 7-03Lowercase 'm' is automatically changed to uppercase 'M.'
Number of decimal places to display for Float columns
Entering a value between 0 and 9 allows you to specify the number of decimal places initially displayed for all data that originated from a FLOAT column. The default value for this option is 2.
You can change the setting for selected columns. From the shortcut menu, select Decimal Places.
Handle Binary/Byte columns as BLOBs if size > Enter a number between 0 and 64000. The default value for this option is 30.
- 0 – All Binary/Byte columns are treated as BLOBs
- 64000 – Binary/Byte columns are never treated as BLOBs
- Other – Binary/Byte columns larger than this value are treated as BLOBs
Each BLOB is returned to a separate file on your PC. Regular Binary/Byte data appears in the grid as a hex string.
Handle Varchar columns as CLOBs if size > Set a size limit after which a Varchar column is handled as a CLOB. The default is 16384.
Control the format of data values that are both displayed the Answerset window and Written to an Export file by setting options on the Data Format tab of the Options dialog.