ABL-to-MS SQL Server data type mapping

DataServer for Microsoft SQL Server

Initial Programming Considerations : Data types : Support for OpenEdge ABL BLOB data type : ABL-to-MS SQL Server data type mapping

The Map to MSS Datetime Type for option is disabled by default for BLOBs in order to provide backward compatibility, which means that the default behavior is to use the behavior from the previous release, mapping to the DATETIME data type, and not the new data types.

The following table depicts mapping between the ABL BLOB data type and its MS SQL Server equivalent during a schema pull.

Table 16. BLOB data type in schema pull
MS SQL Server Data Type		OpenEdge Data Type
MSS 2005	MSS 2008	Prior to 11.0	11.0 and later
VARBINARY(MAX)	VARBINARY(MAX)	CHAR	CHAR, BLOB
IMAGE	IMAGE	CHAR	CHAR, BLOB
	VARBINARY(MAX) FILESTREAM	Non-applicable	BLOB

For more information on ABL-to-MS SQL Server data type mapping, see Data types.