In-row and off-row LOB Storage Support

In Adaptive Server 15.7, LOB columns that are marked for in-row storage 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 Enterprise ODBC Driver 15.7 and jConnect for JDBC 7.07 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.