Amber's Lab

Data Type

SQL Server (SqlClient)

Oracle (OracleClient)

DT_BOOL

bit

DT_BYTES

binary, varbinary, timestamp

raw

DT_CY

smallmoney, money

DT_DATE

date

DT_DBDATE

date

DT_DBTIME

DT_DBTIMESTAMP

datetime, smalldatetime

timestamp, date, interval

DT_DECIMAL

decimal

DT_FILETIME

DT_GUID

uniqueidentifier

DT_I1

DT_I2

smallint

DT_I4

int

DT_I8

bigint

DT_NUMERIC

decimal, numeric

number, int

DT_R4

real

DT_R8

float

float, real

DT_STR

char, varchar

DT_UI1

tinyint

DT_UI2

DT_UI4

DT_UI8

DT_WSTR

char, varchar, nchar, nvarchar, sql_variant, xml

char, rowid, varchar2, nvarchar2, nchar

DT_IMAGE

image

long raw, blob,loblocator, bfile, vargraphic, long vargraphic, user-defined

DT_NTEXT

text, ntext

long, clob, nclob, nvarchar, text

DT_TEXT

text