|
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