[CR #529732 and CR #531316] The Adaptive Server OBDC driver truncates text or image data values that are larger than the value set in the ODBC configuration in Microsoft Windows for the driver.
Workaround: Increase the text size value in the OBDC Control Panel, or set the value in the database options parameter for your database connection.
Increasing the text size value using the Control
Panel
In Control Panel | Administrative Tools | Data Sources (ODBC), 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 and 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.
