Supported ODBC Data Types
The TDV ODBC driver supports and maps the following data types.
Supported Data Type | Data Type is Mapped To |
CHAR, VARCHAR | VARCHAR |
BIT, TINYINT, SMALLINT | SMALLINT |
BIGINT, INT | INT |
DECIMAL, REAL, FLOAT, NUMERIC | FLOAT |
SHORT, LONG, DOUBLE, TIME, DATE, TIMESTAMP | VARCHAR |
Data Types of Unknown Length
The TDV ODBC driver supports retrieval of parameters with values longer than 255 characters if the client provides adequate memory for the task.
If the parameter is a wildcard of unknown length, the parameter is defined with a data type of VARCHAR (255). SQL parameters of a given length submitted in a prepared statement are assigned a data type of CHAR with the actual character length of the parameter submitted.