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
posted @ 2016-10-26 14:38  但行好事-莫问前程  阅读(2565)  评论(0编辑  收藏  举报