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（日期设为2月1日点） |