Data Type Mappings

The following table lists the mappings between variant data types and OLE DB data types.

Variant data type OLE DB data type
VT_BOOL DBTYPE_BOOL
VT_BSTR DBTYPE_BSTR
VT_BYREF DBTYPE_BYREF
VT_CY DBTYPE_CY
VT_DATE DBTYPE_DATE
VT_DECIMAL DBTYPE_DECIMAL
VT_EMPTY DBTYPE_EMPTY
VT_FILETIME DBTYPE_FILETIME
VT_GUID DBTYPE_GUID
VT_I1 DBTYPE_I1
VT_I2 DBTYPE_I2
VT_I4 DBTYPE_I4
VT_I8 DBTYPE_I8
VT_NULL DBTYPE_NULL
VT_R4 DBTYPE_R4
VT_R8 DBTYPE_UI8
VT_VECTOR DBTYPE_VECTOR
VT_WSTR DBTYPE_WSTR

 

The following table lists the mappings between XML data types and OLE DB data types.

Variant data type OLE DB data type
BIN.BASE64 DBTYPE_BYTES
BIN.HEX DBTYPE_I8
BOOLEAN DBTYPE_BOOL
CHAR DBTYPE_STR
DATE DBTYPE_DATE
DATETIME DBTYPE_DATE
DATETIME.TZ DBTYPE_DATE
FIXED.14.4 DBTYPE_R4
FLOAT DBTYPE_R8
I1 DBTYPE_I1
I2 DBTYPE_I2
I4 DBTYPE_I4
I8 DBTYPE_I8
INT DBTYPE_I8
LONG DBTYPE_I4
NUMBER DBTYPE_R8
R4 DBTYPE_R4
R8 DBTYPE_R8
STRING DBTYPE_WSTR
TIME DBTYPE_FILETIME
TIME.TZ DBTYPE_FILETIME
UI1 DBTYPE_UI2
UI2 DBTYPE_UI2
UI4 DBTYPE_UI4
UI8 DBTYPE_UI8
URI DBTYPE_WSTR
UUID DBTYPE_GUID

 

You can cast string data to other data types. For more information,refer to Casting the Data Type of a Column.