ABL-to-MS SQL Server data type mapping
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.
| 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.