Max Single LOB Bytes
MaxSingleLOBBytes
| Key Name | Default Value | Required |
|---|---|---|
|
|
|
No |
Description
The maximum size of the LOBs (in bytes) that the connector can retrieve using Smart LOB (SLOB) Mode. LOBs that exceed this size are retrieved 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_SINGLE_LOB_BYTES 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