text Datatype

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, SAP ASE 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.

Related concepts
Change text, unitext, and image data