JAVA数据类型与DB2、Oracle、Sybase以及SQL Server对应关系

时间:2023-03-10 00:54:37
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