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.
You cannot use the text datatype:
For parameters to stored procedures, as values passed to these parameters, or for local variables
For parameters to remote procedure calls (RPCs)
In order by, compute, group by, or union clauses
In an index
In subqueries or joins
In a where clause, except with the keyword like
With the + concatenation operator
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 User’s Guide for more information.
For more information about the text datatype, see “Changing text, unitext, and image data”.
