Data casting between SQL data types and ADSI data types in SharePoint Portal Server 2003 (838116)

MORE INFORMATION

The following are some things to consider if you map Active Directory properties in SharePoint Portal Server 2003:

• If you map properties that use different data types, the values of the properties may be modified in certain situations. For example, if the property in Active Directory uses a string data type and you map it to a property that uses an integer data type, all non-integer values are converted to use 0 (zero). For example, if the string is ABC, the value of the property is changed to 0 (zero) after the property is mapped.
• When you map properties, try to use the native data property type where it is possible. For example, if the property of the user profile in Active Directory uses an integer data type, map the property to a property that uses the integer data type in the user profile. Do not map the property to a property that uses a different data type. For example, do not map the property to a property that uses the string data type.

The following table contains information about data casting that is supported between SQL data types and ADSI data types when you import user profile information from Active Directory to SharePoint Portal Server 2003:

User profile data type	ADSTYPE_DN_STRING ADSTYPE_CASE_IGNORE_STRING DSTYPE_PRINTABLE_STRING ADSTYPE_INTEGER ADSTYPE_NUMERIC_STRING	DSTYPE_BOOLEAN	ADSTYPE_INTEGER	ADSTYPE_OCTET_STRING	ADSTYPE_UTC_TIME	ADSTYPE_LARGE_INTEGER
Integer	Wcstol (() with base = 0	1/0	Conversion from column data type to row data type is supported.	*	*	*
Big integer	_wtoi64()	*	*	*	*	Conversion from column data type to row data type is supported.
Binary	*	*	*	Truncated, if binary in Active Directory is longer than binary of the property in the user profile.	*	*
Boolean	*	If (lVal<>0){True;} Else{False;}	If (lVal<>0){True;} Else{False;}	*	*	*
Date Date Time	*	*	*	*	VariantTimeToSystemTime Date Time	*
Float	Wcstod()	*	*	*	*	*
String HTML Email URL Person	Truncated, if string in Active Directory is longer than string of the property in the user profile. If truncation of other data types occurs, information is logged to the Search Filter Process log.	ltow() with Radix=10 Truncated, if longer.	ltow() with Radix=10 Truncated, if longer.	*	VariantChangeTypeEx() with Site Locale. Truncated, if longer.	*
Unique Identifier	*	*	*	Conversion from column data type to row data type is supported.	*	*

Note An asterisk character (*) means that conversion is not supported.