The following table lists the data types supported by the MySQL driver and describes how they are mapped to JDBC data types.

Table 1. MySQL Data Types
MySQL Data Type JDBC Data Type
BIGINT BIGINT
BIGINT UNSIGNED BIGINT1
BINARY BINARY
BIT BINARY
BLOB LONGVARBINARY
CHAR(n) CHAR
DATE DATE
DATETIME TIMESTAMP
DECIMAL DECIMAL
DECIMAL UNSIGNED DECIMAL
DOUBLE DOUBLE
DOUBLE UNSIGNED DOUBLE
FLOAT REAL
FLOAT UNSIGNED REAL
INTEGER INTEGER
INTEGER UNSIGNED INTEGER2
LONGBLOB LONGVARBINARY
LONGTEXT LONGVARCHAR
MEDIUMBLOB LONGVARBINARY
MEDIUMINT INTEGER
MEDIUMINT UNSIGNED INTEGER
MEDIUMTEXT LONGVARCHAR
SMALLINT SMALLINT
SMALLINT UNSIGNED SMALLINT
TEXT LONGVARCHAR
TIME TIME
TIMESTAMP TIMESTAMP
TINYBLOB LONGVARBINARY
TINYINT TINYINT
TINYINT UNSIGNED TINYINT
TINYTEXT LONGVARCHAR
VARBINARY(n) VARBINARY
VARCHAR(n) VARCHAR
YEAR SMALLINT
1 To handle large values, the driver internally maps this data type to DECIMAL.
2 To handle large values, the driver internally maps this data type to BIGINT.