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.