Supported data types

Devart ODBC Driver for MySQL supports all MySQL data types.

The following table describes the mapping between the MySQL and ODBC data types.

MySQL data type	ODBC data type
`DECIMAL` `NEWDECIMAL`	`SQL_DECIMAL`
`BIT`	`SQL_INTEGER`
`TINY`	`SQL_TINYINT`
`SHORT`	`SQL_SMALLINT`
`INT24`	`SQL_INTEGER`
`LONG`	`SQL_INTEGER`
`LONGLONG`	`SQL_BIGINT`
`FLOAT`	`SQL_REAL`
`DOUBLE`	`SQL_DOUBLE`
`TIMESTAMP`	`SQL_TYPE_TIMESTAMP`
`DATE` `NEWDATE`	`SQL_TYPE_DATE`
`TIME`	`SQL_TYPE_TIME`
`DATETIME`	`SQL_TYPE_TIMESTAMP`
`YEAR`	`SQL_SMALLINT`
`VAR_STRING` `VARCHAR`	If flagged as binary → `SQL_VARBINARY`, otherwise → `SQL_VARCHAR`
`STRING`	If flagged as binary → `SQL_BINARY`, otherwise → `SQL_CHAR`
`NULL`	`SQL_VARCHAR`
`ENUM`	`SQL_CHAR`
`SET`	`SQL_CHAR`
`TINY_BLOB` `MEDIUM_BLOB` `LONG_BLOB` `BLOB`	If flagged as binary → `SQL_LONGVARBINARY`, otherwise → `SQL_LONGVARCHAR`