ODBC Driver for MySQL

Supported Data Types



ODBC Driver for MySQL supports all the MySQL data types.

The complete list of MySQL data types is available in the MySQL documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to MySQL data types.

MySQL Data Types ODBC Data Types

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 is flagged as binary - SQL_VARBINARY

else - SQL_VARCHAR

STRING

if is flagged as binary - SQL_BINARY

else - SQL_CHAR

NULL

SQL_VARCHAR

ENUM

SQL_CHAR

SET

SQL_CHAR

TINY_BLOB

if is flagged as binary - SQL_LONGVARBINARY

else - SQL_LONGVARCHAR;

MEDIUM_BLOB

LONG_BLOB

BLOB

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback