image Datatype

Use the image datatype to store larger blocks of binary data on external data pages. An image column can store up to 2,147,483,647 bytes of data on linked lists of data pages separate from other data storage for the table.

When you initialize an image 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. Each page stores a maximum of 1800 bytes.

To save storage space, define image columns as NULL. To add image data without saving large blocks of binary data in your transaction log, use writetext. See the Reference Manual: Commands.

You cannot use the image datatype:

If you are using databases connected with Component Integration Services, there are several differences in the way image datatypes are handled. See the Component Integration Services Users Guide.

Related concepts
Change text, unitext, and image data