Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Data types : Support for OpenEdge ABL CLOB data type : ABL-to-MS SQL Server data type mapping
 
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.
Table 15. CLOB 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, CLOB
IMAGE
IMAGE
CHAR
CHAR, CLOB
For more information on ABL-to-MS SQL Server data type mapping, see Data types.