Specifies the maximum number of bytes in character columns an access service returns to the client application.
Data exceeding the TextSize length is truncated without a warning message.
Character data longer than XNLCHAR or XNLVARCHAR bytes is returned as CS_TEXT.
For ECDA Option for ODBC for Microsoft SQL Server targets, 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.