OLE DB Programmer's Reference |
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 |
1998-2001 Microsoft Corporation. All rights reserved.