Text/Image Processing

The driver has several enhancements to the processing of text and image data:

• When connected to SQL Server, the driver uses the UPDATETEXT function in the server to support updating the text and image columns of all rows when the UPDATE statement affects multiple rows.

  When connected to SQL Server 4.2x, only the text and image columns of the first row (of a multirow UPDATE) will be updated.

• The driver exposes a driver-specific statement option (SQL_TEXTPTR_LOGGING) to disable the logging of text and image column operations.
• When using server cursors, the driver does not retrieve text and image data for unbound columns unless the user explicitly issues the SQLGetData call.
• When connected to SQL Server, SQLExecDirect and SQLExecute do not require SQL_LEN_DATA_AT_EXEC, but using it is more efficient.