Data Types and Mappings
Data Types and Mappings
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release. 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 |
Send us your feedback about the Microsoft Exchange Server 2003 SDK.
Build: June 2007 (2007.618.1)
© 2003-2006 Microsoft Corporation. All rights reserved. Terms of use.