Data Types for Teradata

The following table lists the data type support for a Teradata database.
The NCHAR, NVARCHAR, and REAL data types are not supported for data type definition.
For data source specific information about the Teradata data types, see the Teradata database documentation.
Data Types for Teradata
Data Type Definition Keyword1
Teradata Data Type
Description
Data Type Returned
BIGINT
BIGINT
Large signed, exact whole number.
BIGINT
BINARY(n)
BYTE(n)
Fixed-length binary string
BINARY(n)
BLOB
Large Binary Object.
CHAR(n)
CHAR(n)
Fixed-length character string.
CHAR(n)
CLOB
Large Character Object.
DATE
DATE
Date values.
DATE
DECIMAL|NUMERIC(p,s)
DECIMAL(p,s)
Signed, fixed-point decimal number.
DECIMAL(p,s)
DOUBLE
FLOAT
Signed, double precision, floating-point number.
DOUBLE
FLOAT(p)
FLOAT(p)
Signed, double precision, floating-point number.
FLOAT(p)
INTEGER
INTEGER
Regular signed, exact whole number.
INTEGER
LONG VARCHAR
Varying-length character string.
SMALLINT
SMALLINT
Small signed, exact whole number
SMALLINT
TIME(p)
TIME(p)
Time value.
TIME(p)
TIMESTAMP(p)
TIMESTAMP(p)
Date and time value.
TIMESTAMP(p)
TINYINT
BYTEINT
Very small signed, exact whole number.
TINYINT
VARBINARY(n)
VARBYTE(n)
Varying-length binary string.
VARBINARY(n)
VARCHAR(n)
VARCHAR(n)
Varying-length character string.
VARCHAR(n)
1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.
2The Teradata data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type.
Last updated: February 23, 2017