Data Types


Data TypeSQL Server

(SQLOLEDB; SQLNCLI10)
SQL Server (SqlClient)JetOracle

(OracleClient)
DB2

(DB2OLEDB)
DB2

(IBMDADB2)
DT_BOOLbitbitBit
DT_BYTESbinary, varbinary, timestampbinary, varbinary, timestampBigBinary, VarBinaryRAW
DT_CYsmallmoney, moneysmallmoney, moneyCurrency
DT_DATE
DT_DBDATEdate (Transact-SQL)date (Transact-SQL)datedatedate
DT_DBTIMEtimestamptimetime
DT_DBTIME2time (Transact-SQL)(p)time (Transact-SQL) (p)
DT_DBTIMESTAMPdatetime (Transact-SQL)smalldatetime (Transact-SQL)datetime (Transact-SQL)smalldatetime (Transact-SQL)DateTimeTIMESTAMP, DATE, INTERVALTIME, TIMESTAMP, DATETIME, TIMESTAMP, DATE
DT_DBTIMESTAMP2datetime2 (Transact-SQL)datetime2 (Transact-SQL)timestamptimestamptimestamp
DT_DBTIMESTAMPOFFSETdatetimeoffset (Transact-SQL)(p)datetimeoffset (Transact-SQL)(p)timestampoffsettimestamp,

varchar
timestamp,

varchar
DT_DECIMAL
DT_FILETIME
DT_GUIDuniqueidentifieruniqueidentifierGUID
DT_I1
DT_I2smallintsmallintShortSMALLINTSMALLINT
DT_I4intintLongINTEGERINTEGER
DT_I8bigintbigintBIGINTBIGINT
DT_NUMERICdecimal, numericdecimal, numericDecimalNUMBER, INTDECIMAL, NUMERICDECIMAL, NUMERIC
DT_R4realrealSingleREALREAL
DT_R8floatfloatDoubleFLOAT, REALFLOAT, DOUBLEFLOAT, DOUBLE
DT_STRchar, varcharVarCharCHAR, VARCHARCHAR, VARCHAR
DT_UI1tinyinttinyintByte
DT_UI2
DT_UI4
DT_UI8
DT_WSTRnchar, nvarchar, sql_variant, xmlchar, varchar, nchar, nvarchar, sql_variant, xmlLongTextCHAR, ROWID, VARCHAR2, NVARCHAR2, NCHARGRAPHIC, VARGRAPHICGRAPHIC, VARGRAPHIC
DT_IMAGEimageimageLongBinaryLONG RAW, BLOB, LOBLOCATOR, BFILE, VARGRAPHIC, LONG VARGRAPHIC, user-definedCHAR () FOR BIT DATA, VARCHAR () FOR BIT DATACHAR () FOR BIT DATA, VARCHAR () FOR BIT DATA, BLOB
DT_NTEXTntexttext, ntextLONG, CLOB, NCLOB, NVARCHAR, TEXTLONG VARCHAR, NCHAR, NVARCHAR, TEXTLONG VARCHAR, DBCLOB, NCHAR, NVARCHAR, TEXT
DT_TEXTtext







Comments

Popular posts from this blog

Variables