Data Types and Mappings
Topic Last Modified: 2006-06-11
A rich set of single and multivalued data types are provided for item properties in the Exchange store. The following table lists each type using the XML-Data representation. The next table lists the mapping between these data types and the types presented using OLE DB and MAPI.
| Type (XML) | Description |
|---|---|
boolean |
A Boolean value, either TRUE or FALSE. In an XML string, this value is either 1 for TRUE, or 0 for FALSE. |
i2 mv.i2 |
2-byte integer. |
int mv.int |
4-byte integer. |
i8 mv.i8 |
8-byte integer. |
dateTime.tz mv.dateTime.tz |
Date and Time. |
r4 mv.r4 |
4-byte floating point number. |
fixed.14.4 mv.fixed.14.4 |
Fixed floating point number. |
float mv.float |
Floating point number. |
uuid mv.uuid |
universally unique identifier (UUID) in string format. |
string mv.string |
2-byte character string (Unicode). |
bin.base64* mv.bin.base64* |
Binary data (base64 encoded). |
The following table lists the mappings between types in OLE DB (Exchange OLE DB Provider), MAPI, and XML (WebDAV).
Data Types and Mappings
| XML-Data Type | OLE DB Type | MAPI Type |
|---|---|---|
boolean |
DBTYPE_BOOL |
PT_BOOLEAN |
i2 mv.i2 |
DBTYPE_I2 DBTYPE_ARRAY | DBTYPE_I2 |
PT_I2 PT_MV_I2 |
int mv.int |
DBTYPE_I4 DBTYPE_ARRAY | DBTYPE_I4 |
PT_LONG PT_MV_LONG |
i8 mv.i8 |
DBTYPE_I8 DBTYPE_ARRAY | DBTYPE_I8 |
PT_I8 PT_MV_I8 |
dateTime.tz mv.dateTime.tz |
DBTYPE_FILETIME DBTYPE_ARRAY | DBTYPE_FILETIME |
PT_SYSTIME PT_MV_SYSTIME |
dateTime.tz mv.dateTime.tz |
DBTYPE_FILETIME DBTYPE_ARRAY | DBTYPE_FILETIME |
PT_APPTIME PT_MV_APPTIME |
r4 mv.r4 |
DBTYPE_R4 DBTYPE_ARRAY | DBTYPE_R4 |
PT_R4 PT_MV_R4 |
fixed.14.4 mv.fixed.14.4 |
DBTYPE_CY DBTYPE_ARRAY | DBTYPE_CY |
PT_CURRENCY PT_MV_CURRENCY |
float mv.float |
DBTYPE_DOUBLE DBTYPE_ARRAY | DBTYPE_DOUBLE |
PT_DOUBLE PT_MV_DOUBLE |
uuid mv.uuid |
DBTYPE_GUID DBTYPE_ARRAY | DBTYPE_GUID |
PT_CLSID PT_MV_CLSID |
string mv.string |
DBTYPE_WSTR DBTYPE_ARRAY | DBTYPE_WSTR |
PT_UNICODE PT_MV_UNICODE |
string* mv.string* |
DBTYPE_STR DBTYPE_ARRAY | DBTYPE_STR |
PT_STRING8 PT_MV_STRING8 |
bin.base64* mv.bin.base64* |
DBTYPE_BYTES DBTYPE_ARRAY | DBTYPE_BYTES |
PT_BINARY PT_MV_BINARY |
Not Supported |
DBTYPE_ERROR |
PT_ERROR |
Not Supported |
DBTYPE_NULL |
PT_NULL |
Not Supported |
DBTYPE_IUNKNOWN |
PT_OBJECT |
Not Supported |
Not Supported |
PT_UNSPECIFIED |