Share via


Type Indicators in a Microsoft SQL Server Provider

This table shows how a Microsoft SQL Server provider might map its data types to OLE DB data types.

Microsoft SQL Server data type

OLE DB type indicator

char [(n)] (1 = n = 255)

DBTYPE_STR

varchar [(n)] (1 = n = 255)

DBTYPE_STR

binary [(n)] (1 = n = 255)

DBTYPE_BYTES

varbinary [(n)] (1 = n = 255)

DBTYPE_BYTES

numeric [(p[,s])]

DBTYPE_NUMERIC

decimal [(p[,s])]

DBTYPE_NUMERIC

tinyint

DBTYPE_UI1

smallint

DBTYPE_I2

int

DBTYPE_I4

real

DBTYPE_R4

float [(n)]

DBTYPE_R8

smalldatetime

DBTYPE_DATE, DBTYPE_DBTIMESTAMP

datetime

DBTYPE_DATE, DBTYPE_DBTIMESTAMP

timestamp

DBTYPE_BYTES (DBCOLUMNFLAGS_ISROWVER is set)

text

DBTYPE_STR

image

DBTYPE_BYTES

smallmoney

DBTYPE_CY

money

DBTYPE_CY

user-defined-type

DBTYPE_UDT