Mybatis，MyBatis中jdbcType和Oracle以及MySql數據類型對應關系表

2023-10-17 阅读 26 评论 0

摘要：MybatisJdbcTypeOracleMySqlJdbcTypeARRAY??JdbcTypeBIGINT?BIGINTJdbcTypeBINARY??JdbcTypeBIT?BITJdbcTypeBLOBBLOBBLOBJdbcTypeBOOLEAN??JdbcTypeCHARCHARCHARJdbcTypeCLOBCLOBCLOB–>修改為TEXTJdbcTypeCURSOR??JdbcTypeDATEDATEDATEJdbcTypeDECIMALDECIMALDECIMALJdbc

Mybatis	JdbcType	Oracle	MySql
JdbcType	ARRAY	?	?
JdbcType	BIGINT	?	BIGINT
JdbcType	BINARY	?	?
JdbcType	BIT	?	BIT
JdbcType	BLOB	BLOB	BLOB
JdbcType	BOOLEAN	?	?
JdbcType	CHAR	CHAR	CHAR
JdbcType	CLOB	CLOB	CLOB–>修改為TEXT
JdbcType	CURSOR	?	?
JdbcType	DATE	DATE	DATE
JdbcType	DECIMAL	DECIMAL	DECIMAL
JdbcType	DOUBLE	NUMBER	DOUBLE
JdbcType	FLOAT	FLOAT	FLOAT
JdbcType	INTEGER	INTEGER	INTEGER
JdbcType	LONGVARBINARY	?	?
JdbcType	LONGVARCHAR	LONG VARCHAR	?
JdbcType	NCHAR	NCHAR	?
JdbcType	NCLOB	NCLOB	?
dbcType	NUMERIC	NUMERIC/NUMBER	NUMERIC/
JdbcType	NVARCHAR	?	?
JdbcType	OTHER	?	?
JdbcType	REAL	REAL	REAL
JdbcType	SMALLINT	SMALLINT	SMALLINT
JdbcType	STRUCT	?	?
JdbcType	TIME	?	TIME
JdbcType	TIMESTAMP	TIMESTAMP	TIMESTAMP/DATETIME
JdbcType	TINYINT	?	TINYINT
JdbcType	UNDEFINED	?	?
JdbcType	VARBINARY	?	?
JdbcType	VARCHAR	VARCHAR	VARCHAR