MySQL Data Type |
Oracle Data Type |
Java |
BIGINT |
Number (19, 0) |
Java.lang.Long |
BIT |
RAW |
Byte[] |
Blob |
BLOB, RAW |
Byte[] |
CHAR |
CHAR |
Java.lang.String |
DATE |
DATE |
Java.sql.Date |
Datetime |
DATE |
Java.sql.Timestamp |
DECIMAL |
FLOAT (24) |
Java.math.BigDecimal |
DOUBLE |
FLOAT (24) |
Java.lang.Double |
DOUBLE PRECISION |
FLOAT (24) |
Java.lang.Double |
Enum |
VARCHAR2 |
Java.lang.String |
FLOAT |
FLOAT |
Java.lang.Float |
Int |
Number (10, 0) |
Java.lang.Integer |
INTEGER |
Number (10, 0) |
Java.lang.Integer |
Longblob |
BLOB, RAW |
Byte[] |
Longtext |
CLOB, RAW |
Java.lang.String |
Mediumblob |
BLOB, RAW |
Byte[] |
Mediumint |
Number (7, 0) |
Java.lang.Integer |
Mediumtext |
CLOB, RAW |
Java.lang.String |
NUMERIC |
Number |
|
REAL |
FLOAT (24) |
|
SET |
VARCHAR2 |
Java.lang.String |
SMALLINT |
Number (5, 0) |
Java.lang.Integer |
TEXT |
VARCHAR2, CLOB |
Java.lang.String |
Time |
DATE |
Java.sql.Time |
TIMESTAMP |
DATE |
Java.sql.Timestamp |
Tinyblob |
RAW |
Byte[] |
TINYINT |
TINYINT |
Java.lang.Boolean |
Tinytext |
VARCHAR2 |
Java.lang.String |
VARCHAR |
VARCHAR2, CLOB |
Java.lang.String |
Year |
Year |
Java.sql.Date (date set to February 1) |
Comparison of data types of java,mysql,oracle