16.20 - Data Format Tab Default Preference Settings - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
Preference 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