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.
| TINYINT (SIGNED) | TINYINT |
| TINYINT (UNSIGNED) | TINYINT UNSIGNED |
| TINYINT (ZEROFILL) | TINYINT UNSIGNED |
| BOOLEAN | TINYINT |
| INT1 (SIGNED) | TINYINT |
| INT1 (UNSIGNED) | TINYINT UNSIGNED |
| INT1 (ZEROFILL) | TINYINT UNSIGNED |
| SMALLINT (SIGNED) | SMALLINT |
| SMALLINT (UNSIGNED) | SMALLINT UNSIGNED |
| SMALLINT (ZEROFILL) | SMALLINT UNSIGNED |
| INT2 (SIGNED) | SMALLINT |
| INT2 (UNSIGNED) | SMALLINT UNSIGNED |
| INT2 (ZEROFILL) | SMALLINT UNSIGNED |
| MEDIUMINT (SIGNED) | MEDIUMINT |
| MEDIUMINT (UNSIGNED) | MEDIUMINT UNSIGNED |
| MEDIUMINT (ZEROFILL) | MEDIUMINT UNSIGNED |
| INT3 (SIGNED) | MEDIUMINT |
| INT3 (UNSIGNED) | MEDIUMINT UNSIGNED |
| INT3 (ZEROFILL) | MEDIUMINT UNSIGNED |
| INT (SIGNED) | INT |
| INT (UNSIGNED) | INT UNSIGNED |
| INT (ZEROFILL) | INT UNSIGNED |
| INT4 (SIGNED) | INT |
| INT4 (UNSIGNED) | INT UNSIGNED |
| INT4 (ZEROFILL) | INT UNSIGNED |
| BIGINT (SIGNED) | BIGINT |
| BIGINT (UNSIGNED) | BIGINT UNSIGNED |
| BIGINT (ZEROFILL) | BIGINT UNSIGNED |
| INT8 (SIGNED) | BIGINT |
| INT8 (UNSIGNED) | BIGINT UNSIGNED |
| INT8 (ZEROFILL) | BIGINT UNSIGNED |
| DECIMAL (SIGNED) | DECIMAL |
| DECIMAL (UNSIGNED) | DECIMAL UNSIGNED |
| DECIMAL (ZEROFILL) | DECIMAL UNSIGNED |
| FLOAT (SIGNED) | REAL |
| FLOAT (UNSIGNED) | FLOAT UNSIGNED |
| FLOAT (ZEROFILL) | FLOAT UNSIGNED |
| DOUBLE (SIGNED) | FLOAT |
| DOUBLE (UNSIGNED) | DOUBLE UNSIGNED |
| DOUBLE (ZEROFILL) | DOUBLE UNSIGNED |
| BIT | BIT |
| BINARY | BINARY |
| BLOB | BLOB |
| TINYBLOB | TINYBLOB |
| MEDIUMBLOB | MEDIUMBLOB |
| LONGBLOB | LONGBLOB |
| TINYTEXT | TINYTEXT |
| TEXT | TEXT |
| MEDIUMTEXT | MEDIUMTEXT |
| LONGTEXT | LONGTEXT |
| CHAR | CHAR |
| ENUM | ENUM |
| LONG | MEDIUMTEXT |
| LONGVARCHAR | MEDIUMTEXT |
| CHARBYTE | BINARY |
| VARBINARY | VARBINARY |
| VARCHAR | VARCHAR |
| SET | SET |
| DATE | DATE |
| TIME | TIME |
| DATETIME | TIMESTAMP |
| TIMESTAMP | TIMESTAMP |
| YEAR | YEAR |
| POINT | POINT |
| LINESTRING | LINESTRING |
| POLYGON | POLYGON |
| MULTIPOINT | MULTIPOINT |
| MULTILINESTRING | MULTILINESTRING |
| MULTIPOLYGON | MULTIPOLYGON |
| GEOMETRYCOLLECTION | GEOMETRYCOLLECTION |
| GEOMETRY | GEOMETRY |