skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The MySQL Wire Protocol Driver : Data Types
  
Data Types
The following table shows how the MySQL data types map to the standard ODBC data types.
Table 22. 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
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
See Retrieving Data Type Information for more information about data types.
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.