Property Data Types
Topic Last Modified: 2006-06-11
A rich set of single-value and multivalued data types is provided for item properties in the Exchange store. The following table lists these types, using the XML-data representation for each one. The second table lists the mappings between these data types and the types presented using OLE DB and MAPI.
| Types (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. |
uri |
Uniform Resource Identifier in string format. |
uuid, mv.uuid |
GUID in string format. |
string, mv.string |
2-byte character string (Unicode). |
bin.base64 mv.bin.base64 |
Binary data (base 64-encoded). |
Data Type Mappings
The following table lists the mappings between types in Exchange OLE DB (ExOLEDB) provider, MAPI, and XML (WebDAV).
| 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 |