MapBinary Property

Article
07/09/2007

The CursorAdapter MapBinary property enables default data type mapping from ODBC and ADO data types to Visual FoxPro Varbinary Blob types.

The XMLAdapter MapBinary property enables default data type mapping from XML data types to Visual FoxPro Varbinary Blob types.

Read/write at design time and run time.

Object.MapBinary [= lValue]

Return Value

lValue
Enables default data type mapping from for ODBC, ADO, and XML data source types.

The following table describes the values for lValue.

lValue	Description
True (.T.)	For CursorAdapter objects, the following data type mapping occurs by default: ODBC SQL_LONGVARBINARY type maps to Blob type. ODBC SQL_BINARY and SQL_VARBINARY ODBC types map to Varbinary type when the precision of the corresponding column in the data source is equal to or less than 254 bytes. Otherwise, if precision is greater than 254 bytes, these types are mapped to the Blob type. For ADO types, adVarBinary and adBinary map to Varbinary type when the precision of the corresponding column in the data source is equal to or less than 254 bytes. Otherwise, if precision is greater than 254 bytes, these types are mapped to the Blob type. For XMLAdapter objects, the LoadXML method maps all binary types to Varbinary type if their size is less than or equal to 254 bytes. Otherwise, if their size is greater than 254 bytes, binary types map to Blob type. When XMLField DataType property is set to Varbinary or Blob, XMLField IsBinary is set to True (.T.), and XMLField DisableEncode is set to False (.F.) automatically. Note You cannot change the IsBinary and DisableEncode properties while XMLField DataType is set to Varbinary.
False (.F.) (Default)	For CursorAdapter objects, prevents default mapping from remote types to Visual FoxPro Varbinary and Blob types. For more information, see Data Type Conversion Control. For XMLAdapter objects, prevents default mapping from XML types to Visual FoxPro Varbinary and Blob data types. For more information, see Visual FoxPro and XML Schema Data Type Mapping.

True (.T.)

For CursorAdapter objects, the following data type mapping occurs by default:

ODBC SQL_LONGVARBINARY type maps to Blob type.
ODBC SQL_BINARY and SQL_VARBINARY ODBC types map to Varbinary type when the precision of the corresponding column in the data source is equal to or less than 254 bytes. Otherwise, if precision is greater than 254 bytes, these types are mapped to the Blob type.
For ADO types, adVarBinary and adBinary map to Varbinary type when the precision of the corresponding column in the data source is equal to or less than 254 bytes. Otherwise, if precision is greater than 254 bytes, these types are mapped to the Blob type.

For XMLAdapter objects, the LoadXML method maps all binary types to Varbinary type if their size is less than or equal to 254 bytes. Otherwise, if their size is greater than 254 bytes, binary types map to Blob type. When XMLField DataType property is set to Varbinary or Blob, XMLField IsBinary is set to True (.T.), and XMLField DisableEncode is set to False (.F.) automatically.

Note

You cannot change the IsBinary and DisableEncode properties while XMLField DataType is set to Varbinary.

False (.F.) (Default)

For CursorAdapter objects, prevents default mapping from remote types to Visual FoxPro Varbinary and Blob types. For more information, see Data Type Conversion Control.

For XMLAdapter objects, prevents default mapping from XML types to Visual FoxPro Varbinary and Blob data types. For more information, see Visual FoxPro and XML Schema Data Type Mapping.

Remarks

Applies To: CursorAdapter | XMLAdapter

Share via

MapBinary Property

Return Value

Remarks

See Also

Reference

Other Resources

Additional resources