Data Type Mapping
Data Type Mappings
The provider maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| INT | int |
| VARCHAR() | varchar |
| DECIMAL() | decimal |
| DATETIME | datetime |
| BLOB | blob |
| BINARY() | binary |
| BLOB() | tinyblob |
| LONGBLOB | longblob |
| MEDIUMBLOB | mediumblob |
| TINYBLOB | tinyblob |
| VARBINARY() | binary |
| DATE | date |
| DATETIME() | datetime |
| TIME | time |
| TIMESTAMP() | datetime |
| YEAR() | year |
| GEOMETRY | geometry |
| GEOMETRYCOLLECTION | geomcollection |
| LINESTRING | linestring |
| MULTILINESTRING | multilinestring |
| MULTIPOINT | multipoint |
| MULTIPOLYGON | multipolygon |
| POINT | point |
| POLYGON | polygon |
| BIGINT() | bigint |
| DECIMAL | decimal |
| DOUBLE | float |
| FLOAT | real |
| INT() | int |
| MEDIUMINT() | mediumint |
| REAL | float |
| SMALLINT() | smallint |
| TINYINT() | tinyint |
| CHAR() | char |
| JSON | json |
| NCHAR() | char |
| NVARCHAR() | varchar |
| VARCHAR() | varchar |
| BIT() | bit |
| BOOLEAN | tinyint |
| LONGTEXT | longtext |
| MEDIUMTEXT | mediumtext |
| TEXT() | tinytext |
| TINYTEXT | tinytext |
| ENUM | enum |
| SET | set |