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.
| BIGINT | BIGINT |
| BIGSERIAL | BIGINT |
| BSON | WVARCHAR |
| JSON | WVARCHAR |
| BYTE | VARBINARY |
| CHARACTER | WVARCHAR |
| CHARACTER VARYING | WVARCHAR |
| DATE | DATE |
| DATETIME | TIMESTAMP |
| DECIMAL | DECIMAL |
| DECIMAL, Fixed Point | DECIMAL |
| FLOAT | DOUBLE |
| INTEGER | INTEGER |
| INT8 | BIGINT |
| INTERVAL | WVARCHAR |
| MONEY | DECIMAL |
| NCHAR | WVARCHAR |
| NVARCHAR | WVARCHAR |
| SERIAL | INTEGER |
| SMALLFLOAT | REAL |
| SMALLINT | SMALLINT |
| TEXT | WVARCHAR |
| VARCHAR | WVARCHAR |
| BLOB | VARBINARY |
| BOOLEAN | BIT |
| CLOB | WVARCHAR |
| LIST | LIST |
| LVARCHAR | WVARCHAR |
| MULTISET | MULTISET |
| ROW, Named | ROW |
| ROW, Unnamed | WVARCHAR |
| SET | SET |