|
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. | |||