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