MySql - JdbcType - Oracle类型映射
MySql - JdbcType - Oracle类型映射
| MySQL数据类型 | JDBC TYPE | Oracle数据类型 |
| BIGINT | BIGINT | NUMBER(20) |
| TINYINT | TINYINT | NUMBER(2) |
| SMALLINT | SMALLINT | NUMBER(5) |
| MEDIUMINT/INTEGER/INT | INTEGER | INTEGER/INT |
| FLOAT | REAL | REAL |
| DOUBLE | DOUBLE | DOUBLE |
| NUMERIC/DECIMAL | DECIMAL | NUMBER |
| CHAR | CHAR | CHAR |
| VARCHAR | VARCHAR | VARCHAR2 |
| TINYBLOB | BINARY | |
| TINYTEXT | VARCHAR | VARCHAR2 |
| BLOB | BINARY | BLOB |
| TEXT/MEDIUMTEXT/LONGTEXT | LONGVARCHAR | VARCHAR2 |
| LONGBLOB | LONGVARBINARY | BLOB |
| DATE/YEAR | DATE | DATE |
| TIME | TIME | |
| DATETIME/TIMESTAMP | TIMESTAMP | TIMESTAMP |
