首页 > 代码库 > JAVA数据类型与DB2、Oracle、Sybase以及SQL Server对应关系
JAVA数据类型与DB2、Oracle、Sybase以及SQL Server对应关系
java.sql.Types | Java | IBM DB2 | Oracle | Sybase | SQL-SERVER |
BIGINT | java.lang.long | BIGINT | NUMBER (38, 0) | BIGINT | BIGINT |
BINARY | byte[] | CHAR FOR BIT DATA | RAW | BINARY | IMAGE |
BIT | java.lang.Boolean | N/A | BIT | BIT | BIT |
BLOB | byte[] | BLOB | BLOB | BLOB | BLOB |
CHAR | java.lang.String | CHAR, GRAPHIC | CHAR | CHAR | CHAR |
CLOB | java.lang.String | CLOB, DBCLOB | CLOB | CLOB | CLOB |
DATE | java.sql.Date | DATE | DATE | DATE | DATE |
DECIMAL | java.math.BigDecimal | DECIMAL | NUMBER | DECIMAL, MONEY, SMALLMONEY | DECIMAL |
DOUBLE | java.lang.Double | DOUBLE | DOUBLE PRECISION | DOUBLE PRECISION | DOUBLE PRECISION |
FLOAT | java.lang.Double | FLOAT | FLOAT | FLOAT | FLOAT |
INTEGER | java.lang.Integer | INTEGER | INTEGER | INT | INTEGER |
JAVA_OBJECT | java.lang.Object | JAVA_OBJECT | JAVA_OBJECT | JAVA_OBJECT | JAVA_OBJECT |
LONGVARBINARY | byte[] | LONG VARCHAR FOR BIT DATA | LONG RAW | IMAGE | IMAGE |
LONGVARCHAR | java.lang.String | LONG VARCHAR, LONG VARGRAPHIC | LONG | TEXT | TEXT |
NUMERIC | java.math.BigDecimal | NUMERIC | NUMERIC | NUMERIC | NUMERIC |
OTHER | java.lang.Object | OTHER | OTHER | OTHER | OTHER |
REAL | java.lang.Float | REAL | REAL | REAL | REAL |
SMALLINT | java.lang.Integer | SMALLINT | SMALLINT | SMALLINT | SMALLINT |
TIME | java.sql.Time | TIME | DATE | TIME | TIME |
TIMESTAMP | java.sql.Timestamp | TIMESTAMP | DATE | DATETIME, SMALLDATETIME | DATETIME |
TINYINT | java.lang.Bute | SMALLINT | TINYINT | TINYINT | TINYINT |
VARBINARY | byte[] | VARCHAR FOR BIT DATA | RAW | VARBINARY | IMAGE |
VARCHAR | java.lang.String | VARCHAR, VARGRAPHIC | VARCHAR | VARCHAR | VARCHAR |
JAVA数据类型与DB2、Oracle、Sybase以及SQL Server对应关系
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。