The following table lists the data types supported by the MySQL driver, and how they map to the ODBC data types.

Table 1. MySQL Data Types
MySQL ODBC
BIGINT SQL_BIGINT
BIGINT UNSIGNED SQL_BIGINT
BINARY SQL_BINARY
BIT SQL_BINARY
BLOB SQL_LONGVARBINARY
CHAR SQL_CHAR
DATE SQL_TYPE_DATE
DATETIME SQL_TYPE_TIMESTAMP
DECIMAL SQL_DECIMAL
DECIMAL UNSIGNED SQL_DECIMAL
DOUBLE SQL_DOUBLE
DOUBLE UNSIGNED SQL_DOUBLE
FLOAT SQL_REAL
FLOAT UNSIGNED SQL_REAL
INTEGER SQL_INTEGER
INTEGER UNSIGNED SQL_INTEGER
JSON SQL_LONGVARCHAR
LONGBLOB SQL_LONGVARBINARY
LONGTEXT SQL_LONGVARCHAR
MEDIUMBLOB SQL_LONGVARBINARY
MEDIUMINT SQL_INTEGER
MEDIUMINT UNSIGNED SQL_INTEGER
MEDIUMTEXT SQL_LONGVARCHAR
SMALLINT SQL_SMALLINT
SMALLINT UNSIGNED SQL_SMALLINT
TEXT SQL_LONGVARCHAR
TIME SQL_TYPE_TIME
TIMESTAMP SQL_TYPE_TIMESTAMP
TINYBLOB SQL_LONGVARBINARY
TINYINT SQL_TINYINT
TINYINT UNSIGNED SQL_TINYINT
TINYTEXT SQL_LONGVARCHAR
VARBINARY SQL_VARBINARY
VARCHAR SQL_VARCHAR
YEAR SQL_SMALLINT
Note: The Treat Binary Data as Character Data connection option affects how certain ODBC data types are reported. See Treat Binary Data as Character Data for details.