Data Structures Used for Storing text, unitext, and image Data

When you allocate text, unitext, or image data, a 16-byte text pointer is inserted into the row you allocated. Part of this text pointer refers to a text page number at the head of the text, unitext, or image data. This text pointer is known as the first text page.

The first text page contains two parts:

Once an first text page is allocated for text, unitext, or image data, it is never deallocated. If an update to an existing text, unitext,or image data row results in fewer text pages than are currently allocated for this text, unitext, or image data, the SAP ASE server deallocates the extra text pages. If an update to text, unitext, or image data sets the value to NULL, all pages except the first text page are deallocated.

This figure shows the relationship between the data row and the text pages.

Relationship Between the Text Pointer and Data Rows
This figure shows the relationship between the text pointer and data rows.

In the figure, columns c_text and c_image are text and image columns containing the pages at the bottom of the picture.