Data Types for MySQL

The following table lists the data type support for a MySQL database.

The NCHAR, NVARCHAR, REAL, and VABINARY data types are not supported for data type definition.

For data source specific information about MySQL data types, see the MySQL database documentation.

Data Types for MySQL
Data Type Definition Keyword1	MySQL Data Type	Description	Data Type Returned
BIGINT	BIGINT	Large signed, exact whole number.	BIGINT
BINARY(n)	BINARY(n)	Fixed-length binary string.	BINARY(n)
2	BLOB	Varying-length binary large object string.	2
CHAR(n)	CHAR(n)	Fixed-length character string.	CHAR(n)
DATE	DATE	Date values.	DATE
2	DATETIME	Date and time value.	2
DECIMAL\|NUMERIC(p,s)	DECIMAL(p,s)	Signed, fixed-point decimal number.	DECIMAL(p,s)
DOUBLE	DOUBLE	Signed, double precision, floating-point number.	DOUBLE
2	ENUM(values)	Character values from a list of allowed values.	2
FLOAT(p)	FLOAT(p)	Signed, single precision or double precision, floating-point number.	FLOAT(p)
INTEGER	INT	Regular signed, exact whole number.	INTEGER
2	LONGBLOB	Varying-length binary data.	2
2	LONGTEXT	Varying-length character string.	2
2	MEDIUMBLOB	Varying-length binary data.	2
2	MEDIUMINT	Regular signed, exact whole number.	2
2	MEDIUMTEXT	Varying-length character string.	2
2	SET(values)	Character values from a list of allowed values.	2
SMALLINT	SMALLINT	Small signed, exact whole number.	SMALLINT
2	TEXT	Varying-length text data.	2
TIME(p)	TIME(p)	Time value.	TIME(p)
TIMESTAMP(p)	TIMESTAMP(p)	Date and time value.	TIMESTAMP(p)
2	TINYBLOB	Varying-length binary large object string.	2
TINYINT	TINYINT	Very small signed, exact whole number.	TINYINT
2	TINYTEXT	Varying-length text data.	2
VARCHAR(n)	VARCHAR(n)	Varying-length character string.	VARCHAR(n)
1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.
2The MySQL data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type.