Here is a data type mapping from MySQL and MariaDB native data types to application generic data types. Any data type not listed in this table is mapped to Other generic data type.
| Native data type | Generic data type |
| bigint | Number |
| binary | Binary |
| blob | Binary |
| char | String |
| date | DateTime |
| datetime | DateTime |
| decimal | Number |
| double | Number |
| float | Number |
| int | Number |
| longblob | Binary |
| longtext | String |
| mediumblob | Binary |
| mediumint | Number |
| mediumtext | String |
| smallint | Number |
| text | String |
| timestamp | DateTime |
| tinyblob | Binary |
| tinyint | Number |
| tinytext | String |
| varbinary | Binary |
| varchar | String |
Last updated: 2023-10-10
