MySQL data types and Java data types comparison list

MySQL Types to Java Types for Resultset.getobject ()

of

MySQL Type Name	Return value GetColumnClassName	returned as Java Class
BIT(1)(New in MySQL-5.0)	BIT	java.lang.Boolean
BIT( > 1)(New in MySQL-5.0)	BIT	byte[]
TINYINT	TINYINT	java.lang.BooleanIf the configuration property tinyInt1isBit true was set to (the default) and the storage size was 1, or java.lang.Integer if not.
BOOL,BOOLEAN	TINYINT	See TINYINT , above as these TINYINT(1) is aliases for, currently.
SMALLINT[(M)] [UNSIGNED]	SMALLINT [UNSIGNED]	java.lang.Integer(regardless if UNSIGNED or not)
MEDIUMINT[(M)] [UNSIGNED]	MEDIUMINT [UNSIGNED]	java.lang.Integer,If UNSIGNED java.lang.Long (c/j 3.1 and earlier), or for java.lang.Integer c/j 5.0 and later
INT,INTEGER[(M)] [UNSIGNED]	INTEGER [UNSIGNED]	java.lang.Integer, if UNSIGNEDjava.lang.Long
BIGINT[(M)] [UNSIGNED]	BIGINT [UNSIGNED]	java.lang.Long, if UNSIGNEDjava.math.BigInteger
FLOAT[(M,D)]	FLOAT	java.lang.Float
DOUBLE[(M,B)]	DOUBLE	java.lang.Double
DECIMAL[(M[,D])]	DECIMAL	java.math.BigDecimal
DATE	DATE	java.sql.Date
DATETIME	DATETIME	java.sql.Timestamp
TIMESTAMP[(M)]	TIMESTAMP	java.sql.Timestamp
TIME	TIME	java.sql.Time
YEAR[(2|4)]	YEAR	If yearIsDateType Configuration Property false was set to and then the returned object type is java.sql.Short . If set true to (the default) and then the returned object was of type java.sql.Date with the date set to January 1st, at midnight.
CHAR(M)	CHAR	java.lang.String(unless the character set BINARY for the column are, then byte[] is returned.)
VARCHAR(M) [BINARY]	VARCHAR	java.lang.String(unless the character set BINARY for the column are, then byte[] is returned.)
BINARY(M)	BINARY	byte[]
VARBINARY(M)	VARBINARY	byte[]
TINYBLOB	TINYBLOB	byte[]
TINYTEXT	VARCHAR	java.lang.String
BLOB	BLOB	byte[]
TEXT	VARCHAR	java.lang.String
MEDIUMBLOB	MEDIUMBLOB	byte[]
MEDIUMTEXT	VARCHAR	java.lang.String
LONGBLOB	LONGBLOB	byte[]
LONGTEXT	VARCHAR	java.lang.String
ENUM(‘value1‘,‘value2‘,...)	CHAR	java.lang.String
SET(‘value1‘,‘value2‘,...)	CHAR	java.lang.String

MySQL data types and Java data types comparison list