1、VARCHAR和LONG VARGRAPHIC自动对映到LONG VARCHAR。VARCHAR和VARGRAPHIC自动对映到VARCHAR。CLOB和DBCLOB自动对映到CLOB。如果您要使用其他类型,请手动在您的编写资料库中建立自订表格。 使用者应该注意IBM DB2会自动为CHAR FOR BITDATA类型填补空格(x20)。因此,虽然可以使用CHAR FOR BIT DATA来储存BINARY资讯,但是VARCHAR FOR BIT DATA(VARBINARY)通常较适合用来储存非ACSII二进位资讯的小型二进位类型。注:与Oracle、IBM Content Manager、
2、Informix及SQLServer的编写整合作业并未显示在一般可用性中。java.sql.Types 值Java 类型IBM DB2OracleSybaseSQLInformixIBM ContentManager BIGINTjava.lang.longNUMBER (38, 0)INT8DK_CM_BIGINTBINARYbyteCHAR FOR BIT DATARAWIMAGEBYTEDK_CM_BLOBBITjava.lang.BooleanN/ADK_CM_SMALLINTBLOBCHARjava.lang.StringCHAR, GRAPHICDK_CM_CHARCLOBCLOB
3、, DBCLOBDK_CM_CLOBDATEjava.sql.DateDK_CM_DATEDECIMALjava.math.BigDecimalNUMBERDECIMAL, MONEY, SMALLMONEYDK_CM_DECIMALDOUBLEjava.lang.DoubleDOUBLE PRECISIONDK_CM_DOUBLEFLOATINTEGERjava.lang.IntegerINTDK_CM_INTEGERJAVA_OBJECTjava.lang.ObjectOPAQUELONGVARBINARYLONG VARCHAR FOR BIT DATALONG RAWLONGVARCH
4、ARLONG VARCHAR, LONG VARGRAPHICLONGTEXTDK_CM_VARCHAR(3500)NUMERICOTHERREALjava.lang.FloatSMALLINTTIMEjava.sql.TimeDATETIME HOUR TO SECONDDK_CM_TIMETIMESTAMPjava.sql.TimestampDATETIME, SMALLDATETIMEDATETIMEDATETIME YEAR TO FRACTION (5)DK_CM_TIMESTAMPTINYINTjava.lang.ButeVARBINARYVARCHAR FOR BIT DATAVARCHARVARCHAR, VARGRAPHICDK_CM_VARCHAR