jConnect 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 jConnect 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
jConnect supports using text, unitext, and image as input parameters in stored procedures and as parameter marker datatypes.
