ODBC Driver for MySQL

Supported Data Types - ODBC Driver for MySQL

Data Type Mapping

The Devart ODBC Driver for MySQL supports all MySQL data types.

The following table describes how the MySQL data types are mapped to the ODBC 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-2024 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback