Export (0) Print
Expand All

Type Indicators in an ANSI SQL Provider

This table shows how an ANSI SQL provider might map its data types to OLE DB data types.

SQL data type

OLE DB type indicator

CHAR (n)

DBTYPE_STR

VARCHAR (n)

DBTYPE_STR

CLOB

DBTYPE_STR

DECIMAL (p, s)

DBTYPE_NUMERIC

NUMERIC (p, s)

DBTYPE_NUMERIC

BIT

DBTYPE_BOOL

TINYINT

DBTYPE_I1

SMALLINT

DBTYPE_I2

INTEGER

DBTYPE_I4

BIGINT

DBTYPE_I8

REAL

DBTYPE_R4

FLOAT

DBTYPE_R8

DOUBLE PRECISION

DBTYPE_R8

BINARY (n)

DBTYPE_BYTES

VARBINARY (n)

DBTYPE_BYTES

BLOB

DBTYPE_BYTES

DATE

DBTYPE_DBDATE

TIME

DBTYPE_DBTIME

TIMESTAMP

DBTYPE_DBTIMESTAMP

Show:
© 2015 Microsoft