Specifies the initial size (in bytes) of the buffer in which the driver places column values when they are retrieved. This option sets the initial size only; the buffer will adjust dynamically as needed to accommodate larger values. For optimal memory usage, the size of the buffer only needs to be as large as the data it holds.
Valid values
-1 | 0 | x
where:
x
is an integer from 1 to 2147483648.
Behavior
If set to -1 or 0, the driver automatically determines an initial column buffer size that is based on the width of the column being bound.
If set to x, the driver adjusts the buffer to the specified size.
Example
If the driver retrieves data from a CHAR(4000) column and that data is typically no more than 75 bytes in size, reducing the initial column buffer size to 75 bytes (InitialColumnBufferSize=75) will conserve memory on the client or application server.
