Kbase P145261: Is OpenEdge BLOB Data Type supported for MS SQL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/7/2011 |
|
Status: Verified
GOAL:
Is OpenEdge BLOB Data Type supported for MS SQL?
GOAL:
Is it possible to read more than 32K from a MS SQL text field?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
MS SQL DataServer
FIX:
In OpenEdge 10.2B, DataServer for MS SQL Server was enhanced to use the OpenEdge BLOB data type, enabling you to handle data records of up to 1 gigabyte in size. Release 10.2B provides the following enhancements:
The ability to migrate an OpenEdge database with BLOB data type to a MS SQL Server database as VARBINARY (MAX) and pull back as BLOB in the schema holder
The ability to pull MS SQL Server data types VARBINARY (MAX), IMAGE, or VARBINARY (MAX) FILESTREAM as an OpenEdge BLOB data type into the schema holder
The ability to read or write data to or from the MS SQL Server database through the ABL BLOB data type by using the ABL COPY-LOB operation
It is only possible to perform an entire BLOB read and write operation through the COPY-LOB statement. COPY-LOB capabilities for the MS SQL Server DataServer exclude the use of offset operations via the STARTING AT, OVERLAY, and FOR copy phrases. The BLOB data type is not supported in OpenEdge releases prior to 10.2B. Although the MS SQL Server text and image fields can hold up to 2MB, these releases of OpenEdge retrieve only up to 32,000 bytes.