Data Format Tab Default Preference Settings
|
Preferences |
Default |
Description |
|
BinAsBlobSize |
30 |
BYTE columns larger than 30 are treated as BLOBs |
|
CharAsClobSize |
16384 |
CHAR columns larger than 16384 are treated as CLOBs |
|
DashesInBinary |
True |
Include dashes between bytes in binary data |
|
DateFormat |
NA |
Display dates using the current Windows locale settings |
|
NullString |
? |
Display a '?' when the column value is null |
|
Dec16AsStr |
False |
Do not display Decimal(16), and above, values as character strings (used for Excel compatibility) |
|
NumDecimals |
2 |
Two decimal places appear for data that originates from Float columns |
|
ClobWriteBOM |
False |
A Byte Order Mark is not written to CLOB files |