Large Decimal and BIGINT Support - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
ktb1507075385726
Product Category
Teradata Tools and Utilities

ODBC Driver for Teradata supports the use of DECIMAL data types with a precision of 38. An application can determine the maximum precision by calling the ODBC API function SQLGetTypeInfo.

ODBC Driver for Teradata supports 19-digit precision for BIGINT data. The BIGINT data type has an exact numeric value with precision 19 and scale 0. The BIGINT is signed and has a range between -263 ≤ n ≤ 263 - 1 or from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. It includes most (but not all) values with a decimal precision of 19.