|
Supported Data Types - ODBC Driver for MySQL |
|
|
|
Supported Data Types - ODBC Driver for MySQL |
|
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 |