MySQL and Java data type comparison

Type name	Display length	Database type	Java type	JDBC Type index (int)	Describe
VARCHAR	L+n	VARCHAR	Java.lang.String	12
CHAR	N	CHAR	Java.lang.String	1
Blob	L+n	Blob	Java.lang.byte[]	-4
TEXT	65535	VARCHAR	Java.lang.String	-1
INTEGER	4	INTEGER UNSIGNED	Java.lang.Long	4
TINYINT	3	TINYINT UNSIGNED	Java.lang.Integer	-6
SMALLINT	5	SMALLINT UNSIGNED	Java.lang.Integer	5
Mediumint	8	Mediumint UNSIGNED	Java.lang.Integer	4
BIT	1	BIT	Java.lang.Boolean	-7
BIGINT	20	BIGINT UNSIGNED	Java.math.BigInteger	-5
FLOAT	4+8	FLOAT	Java.lang.Float	7
DOUBLE	22	DOUBLE	Java.lang.Double	8
DECIMAL	11	DECIMAL	Java.math.BigDecimal	3
BOOLEAN	1	With tinyint
Id	11	PK (INTEGER UNSIGNED)	Java.lang.Long	4
DATE	10	DATE	Java.sql.Date	91
Time	8	Time	Java.sql.Time	92
Datetime	19	Datetime	Java.sql.Timestamp	93
TIMESTAMP	19	TIMESTAMP	Java.sql.Timestamp	93
Year	4	Year	Java.sql.Date	91

MySQL vs. Java data type