The text datatype stores up to 2,147,483,647 bytes of printable characters on linked lists of separate data pages. Each page stores a maximum of 1800 bytes of data.
To save storage space, define text columns as NULL. When you initialize a text column with a non-null insert or update, Adaptive Server assigns a text pointer and allocates an entire 2K data page to hold the value.
If you are using databases connected with Component Integration Services, there are several differences in the way text datatypes are handled. See the Component Integration Services Users Guide.
For more information about the text datatype, see “Changing text, unitext, and image data” and the Reference Manual: Building Blocks.
