myBatis jdbctype 0racle mysql对应

最新推荐文章于 2022-05-07 16:39:11 发布

qq_36483633

最新推荐文章于 2022-05-07 16:39:11 发布

阅读量238

点赞数

本文链接：https://blog.csdn.net/qq_36483633/article/details/78374052

版权

1. Mybatis JdbcType与Oracle、MySql数据类型对应列表

Mybatis JdbcType Oracle MySql

JdbcType ARRAY
JdbcType BIGINT                                                     BIGINT
JdbcType BINARY
JdbcType BIT    BIT
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
JdbcType NULL
JdbcType 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
JdbcType CLOB CLOB CLOB–>修改为TEXT