Data Types

The Simba MySQL ODBC Driver supports many common data formats, converting between MySQL data types and SQL data types.

The table below lists the supported data type mappings.

MySQL Type	SQL Type
BIGINT BIGINT UNSIGNED	SQL_BIGINT Note: SQL_INTEGER is returned instead if the Treat BIGINT Columns As INT Columns option (the `No_BIGINT` property) is enabled.
BINARY	SQL_BINARY
BIT (M)	SQL_BIT when M = 1 SQL_BINARY when M > 1
BLOB	SQL_LONGVARBINARY
BOOL BOOLEAN	SQL_TINYINT
CHAR	SQL_WCHAR
DATE	SQL_TYPE_DATE if the application uses ODBC version 3.00 or later. SQL_DATE if the application uses an ODBC version earlier than 3.00.
DATETIME	SQL_TYPE_TIMESTAMP if the application uses ODBC version 3.00 or later. SQL_TIMESTAMP if the application uses an ODBC version earlier than 3.00.
DEC DECIMAL	SQL_DECIMAL
DOUBLE DOUBLE PRECISION	SQL_DOUBLE
ENUM	SQL_WCHAR
FLOAT	SQL_REAL
GEOMETRY	SQL_LONGVARBINARY
GEOMETRYCOLLECTION	SQL_LONGVARBINARY
INT INTEGER INTEGER UNSIGNED	SQL_INTEGER
JSON Note: Only supported in MySQL 5.7 or later.	SQL_BINARY
LINESTRING	SQL_LONGVARBINARY
LONGBLOB	SQL_LONGVARBINARY
LONGTEXT	SQL_WLONGVARCHAR
MEDIUMBLOB	SQL_LONGVARBINARY
MEDIUMINT MEDIUMINT UNSIGNED	SQL_INTEGER
MEDIUMTEXT	SQL_WLONGVARCHAR
MULTIPOINT MULTILINESTRING MULTIPOLYGON	SQL_LONGVARBINARY
NUMERIC	SQL_DECIMAL
POINT	SQL_LONGVARBINARY
POLYGON	SQL_LONGVARBINARY
SET	SQL_WCHAR
SMALLINT SMALLINT UNSIGNED	SQL_SMALLINT
TEXT	SQL_WLONGVARCHAR
TIME	SQL_TYPE_TIME if the application uses ODBC version 3.00 or later. SQL_TIME if the application uses an ODBC version earlier than 3.00.
TIMESTAMP	SQL_TYPE_TIMESTAMP if the application uses ODBC version 3.00 or later. SQL_TIMESTAMP if the application uses an ODBC version earlier than 3.00.
TINYBLOB	SQL_LONGVARBINARY
TINYINT TINYINT UNSIGNED	SQL_TINYINT
TINYTEXT	SQL_WLONGVARCHAR
VARBINARY	SQL_VARBINARY
VARCHAR	SQL_WVARCHAR
YEAR	SQL_SMALLINT