The SQL Executable imposes a text limit of 32700 bytes per column; SQL Server uses a default textsize of four kilobytes. If the TRANSACT-SQL set command is not issued, no more than four kilobytes of data will be transferred to or from any column (no matter how much data the SQL statement or column contains). No matter what the SQL textsize is set to, no more than 32700 bytes per column will be transferred.

To query or update a table that contains a SQL Server TEXT or IMAGE column containing more than four kilobytes of data, the SQL Server textsize must be set.  To do this, issue the TRANSACT-SQL set command, which is described in the SQL Server documentation.

Note: The TRANSACT-SQL set command will be interpreted by the local application as a local column formatting command; to force the set command to be treated as an SQL command, add a "\" character to the beginning of the command. See the description of the SQL Executable set command in Part II of this manual for details.