The Adaptive Server ODBC driver truncates text or image data values that are larger than the value set in the ODBC configuration in Microsoft Windows for the driver. You must increase the text size value in the ODBC Control Panel, or set the value in the database options parameter for your database connection to avoid this issue.
Increasing the text size value using the Control
Panel
Select Control Panel | Administrative Tools | Data Sources (ODBC), then select the data source for Adaptive Server Enterprise in the User DSN or System DSN tab.
Select Configure to display the ODBC Adaptive Server Enterprise Setup window, then select Advanced.
Change the value for Text Size to a value larger than 32KB, which is the default. The Adaptive Server ODBC drive truncates any data value that is larger than the value you set here.
Increasing the text size value using Database
Options
In the Properties window for the database connection, double-click the edit icon of the Database Options field to display the Enter Properties window.
In the “Extended Connect Options” field, enter “TEXTSIZE=N” where N is the text size value you want to set.
