Type Indicators in an ANSI SQL Provider

OLE DB Programmer's Reference

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

1998-2001 Microsoft Corporation. All rights reserved.