|
Data Type Mapping in Rowsets and Parameters Advantage OLE DB Provider (for ADO) |
|
|
|
Data Type Mapping in Rowsets and Parameters Advantage OLE DB Provider (for ADO) |
|
|
In rowsets and as parameter values, the Advantage OLE DB Provider represents the Advantage Database Server data by using the following OLE DB defined data types, reported in the functions IColumnsInfo::GetColumnInfo and ICommandWithParameters::GetParameterInfo.
Advantage Database Server Data Type |
Advantage OLE DB Provider Data Type |
ShortInt |
DBTYPE_I2 |
Integer |
DBTYPE_I4 |
Double |
DBTYPE_R8 |
CurDouble |
DBTYPE_R8 |
Logical |
DBTYPE_BOOL |
AutoIncrement |
DBTYPE_UI4 |
Binary |
DBTYPE_BYTES |
Image |
DBTYPE_BYTES |
Raw |
DBTYPE_BYTES |
Character |
DBTYPE_STR |
CICharacter |
DBTYPE_STR |
Memo |
DBTYPE_STR |
Numeric |
DBTYPE_NUMERIC |
Date |
DBTYPE_DBDATE |
ShortDate |
DBTYPE_DBDATE |
Time |
DBTYPE_DBTIME |
TimeStamp |
DBTYPE_DBTIMESTAMP |
Money |
DBTYPE_CY |
RowVersion |
DBTYPE_UI8 |
ModTime |
DBTYPE_DBTIMESTAMP |
The Advantage OLE DB Provider supports conversion to and from most data types. For detailed information about the availability of type conversions on a command or on a rowset, call IConvertType::CanConvert.
The Advantage OLE DB Provider only supports converting to ByRef data types if the destination type is a variable-length data type such as DBTYPE_BYTES, DBTYPE_STR, DBTYPE_VARNUMERIC, or DBTYPE_WSTR.