The Devart ODBC Driver for QUESTDB supports all QUESTDB data types.
The following table describes how the QUESTDB data types are mapped to the ODBC data types.
QuestDB Data Types | ODBC Data Types |
---|---|
BOOLEAN |
SQL_BIT |
BYTE |
SQL_SMALLINT |
SHORT |
SQL_SMALLINT |
INT |
SQL_INTEGER |
LONG |
SQL_BIGINT |
FLOAT |
SQL_REAL |
DOUBLE |
SQL_DOUBLE |
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
DATE |
SQL_TYPE_TIMESTAMP |
CHAR |
SQL_PG_CHARACTER |
SYMBOL |
SQL_PG_VARCHAR |
LONG256 |
SQL_VARCHAR |
STRING |
SQL_PG_VARCHAR |
BINARY |
SQL_LONGVARBINARY |