Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Data Types and Mappings

Data Types and Mappings

Exchange Server 2003

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
Show:
© 2015 Microsoft