Data Types
The following table specifies the binding of the OLE DB types to Teradata data types.
|
OLE DB Data Type Indicator |
Teradata Data Type |
|
DBTYPE_BYTES |
BYTE |
|
DBTYPE_BYTES |
VARBYTE |
|
DBTYPE_BYTES |
INTERVAL |
|
DBTYPE_BYTES |
BLOB |
|
DBTYPE_DBDATE |
DATE |
|
DBTYPE_DBTIME |
TIME |
|
DBTYPE_I1 |
BYTEINT |
|
DBTYPE_I2 |
SMALLINT |
|
DBTYPE_I4 |
INTEGER |
|
DBTYPE_I8 |
BIGINT |
|
DBTYPE_NUMERIC |
DECIMAL |
|
DBTYPE_R8 |
FLOAT |
|
DBTYPE_STR, DBTYPE_WSTR* |
CHAR |
|
DBTYPE_STR, DBTYPE_WSTR* |
VARCHAR |
|
DBTYPE_STR, DBTYPE_WSTR* |
CLOB |
|
DBTYPE_TIMESTAMP |
TIMESTAMP |
* The type associated with CHAR, VARCHAR, and CLOB is DBTYPE_STR if the session character set is ASCII, KANJIJIS_OS. If the session character set is either UTF8 or UTF16, then the type associated is DBTYPE_WSTR.