text, unitext, and image values can be quite large. When a select list includes text, unitext, image, and values, the limit on the length of the data returned depends on the setting of the @@textsize global variable. The default setting for @@textsize depends on the software you use to access Adaptive Server; the default value is 32K for isql. To change the value, use the set command:
set textsize 25
With this setting of @@textsize, a select statement that includes a text column displays only the first 25 bytes of the data.
When
you select image data, the returned value includes
the characters “0x”, which indicates that the
data is hexadecimal. These two characters are counted as part of @@textsize.
To reset @@textsize to the Adaptive Server default value, use:
set textsize 0
The default display is the actual length of the data when its size is less than textsize. For more information about text, unitext, and image datatypes, see Chapter 6, “Using and Creating Datatypes.”
