Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| INTEGER | int |
| VARCHAR | varchar |
| DATE | date |
| TIME | time |
| SECONDDATE | datetime |
| TIMESTAMP | datetime |
| TINYINT | tinyint |
| SMALLINT | smallint |
| BIGINT | bigint |
| DECIMAL | decimal |
| SMALLDECIMAL | decimal |
| REAL | varchar |
| DOUBLE | real |
| FLOAT | varchar |
| BOOLEAN | tinyint |
| NVARCHAR | varchar |
| ALPHANUM | varchar |
| SHORTTEXT | varchar |
| VARBINARY | binary |
| BLOB | binary |
| CLOB | varchar |
| NCLOB | binary |
| TEXT | binary |
| BINTEXT | binary |
| ARRAY | varchar |