Specifies the maximum number of bytes in character columns an access service returns to the client application.
TextSize=integer
0 - 2147483647
2147483647
integer is a number of bytes.
A value of 0 defaults to 2147483647.
The access service truncates data exceeding the TextSize length and does not issue a warning message.
The access service returns character data longer than XNLCHAR or XNLVARCHAR bytes as CS_TEXT.
For DirectConnect for Microsoft SQL Server, how the data is queried determines the text and image results processing. Queries with a select list of a single text or image column results in data streaming. If data is streamed, a maximum of 2,147,483,647 bytes may be returned per text and image value. Queries with a select list containing more than one column results in bound data. All bound data, including text and image is limited to 32,767 bytes. The textsize configuration property applies to both streaming and bound character data.
Text data manipulation using text pointers is only supported
for DirectConnect for Microsoft SQL Server.
