Adaptive Server ODBC Driver supports using Large Object (LOB) datatypes — text, unitext, and image as:
LOB columns with in-row storage
In Adaptive Server, LOB columns that are marked for in-row are stored in-row when there is adequate memory to hold the entire row. When the size of a row increases over its defined limit due to an update to any column in it, the LOB columns which are stored in-row are moved off-row to bring it within the limits. See Chapter 21, "In-Row Off-Row LOB" in the Adaptive Server Enterprise Transact-SQL Users Guide.
The bulk insert routines in Adaptive Server ODBC Driver support the in-row and off-row storage of text, image, and unitext LOB columns in Adaptive Server. Bulk insert routines from earlier client versions always store LOB columns off row.
LOB objects as parameters of stored procedures
Adaptive Server ODBC Driver supports using text, unitext, and image as input parameters in stored procedures and as parameter marker datatypes.
