MariaDB Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
MariaDB Datatype Mapping
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
We match MariaDB data types to Rivery data types while extracting your data. If a data type is not supported, we will map it as a String type.
The following table shows the mapping of MariaDB data types to Rivery-compatible types:
| MariaDB Type | Rivery Type |
|---|---|
| VARBINARY | STRING |
| NCHAR | STRING |
| INTEGER | INTEGER |
| FLOAT | FLOAT |
| DECIMAL | FLOAT |
| CHAR | STRING |
| NUMERIC | FLOAT |
| NVARCHAR | STRING |
| SMALLINT | INTEGER |
| TEXT | STRING |
| VARCHAR | STRING |
| BIGINT | INTEGER |
| BINARY | STRING |
| TINYINT | INTEGER |
| TIMESTAMP | TIMESTAMP |
| REAL | INTEGER |
| DATE | DATE |
| BIT | BOOLEAN |
| BLOB | STRING |
| BOOLEAN | BOOLEAN |
| DATETIME | TIMESTAMP |
| DOUBLE | FLOAT |
| ENUM | STRING |
| LONGBLOB | STRING |
| LONGTEXT | STRING |
| MEDIUMBLOB | STRING |
| MEDIUMINT | INTEGER |
| MEDIUMTEXT | STRING |
| SET | STRING |
| TINYBLOB | STRING |
| TINYTEXT | STRING |
| YEAR | INTEGER |
Was this article helpful?