MySQL Data Type | JDBC Data Type |
BIGINT | BIGINT |
BIGINT UNSIGNED | BIGINT |
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 | INTEGER |
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 | VARBINARY |
VARCHAR(n) | VARCHAR |
YEAR | SMALLINT |