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 | SECONDDATE |
| TIMESTAMP | TIMESTAMP |
| TINYINT | TINYINT |
| SMALLINT | SMALLINT |
| BIGINT | BIGINT |
| DECIMAL | DECIMAL |
| SMALLDECIMAL | SMALLDECIMAL |
| REAL | REAL |
| DOUBLE | FLOAT |
| FLOAT | REAL |
| BOOLEAN | BIT |
| NVARCHAR | NVARCHAR |
| ALPHANUM | ALPHANUM |
| SHORTTEXT | SHORTTEXT |
| VARBINARY | VARBINARY |
| BLOB | BLOB |
| CLOB | CLOB |
| NCLOB | NCLOB |
| TEXT | TEXT |
| BINTEXT | BINTEXT |
| ARRAY | ARRAY |