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

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对应关系

标签：blob   rac   type   ase   arch   size   lda   var   eal