Max Total LOB Bytes Per Row
MaxTotalLOBBytesPerRow
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |
Description
The maximum size of LOB data per row (in bytes) that the connector can retrieve using Smart LOB (SLOB) Mode. If the total amount of LOB data contained in a row exceeds this size, then the connector retrieves the LOBs from that row using Deferred Mode instead.
If this option is set to 0, SLOB Mode is disabled, and the connector retrieves all LOB data using Deferred Mode. For more information, see LOB Retrieval Modes.
Note:
As an alternative to using this option, you can specify this setting on the statement level rather than the connection level by using the SQL_ATTR_MAX_LOB_BYTES_PER_ROW statement attribute.
- Advanced Driver Configuration Options on page 1
- LOB Retrieval Modes
- Configuring Advanced Options
- Creating a Data Source Name
- Configuring a DSN-less Connection
- Using a Connection String