| Mysql |
Oracle |
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 |
NUMBER(3,0) |
java.lang.Boolean |
| TINYTEXT |
VARCHAR2 |
java.lang.String |
| VARCHAR |
VARCHAR2 CLOB |
java.lang.String |
| YEAR |
NUMBER |
java.sql.Date（日期设为2月1日晚上2点） |
|
