Simple Large Objects

Simple large objects are a category of large objects that have a theoretical size limit of 2³¹ bytes and a practical limit that your disk capacity determines. HCL OneDB™ supports these simple-large-object data types:

BYTE

Stores binary data. For more detailed information about this data type, see the description on page BYTE data type.

TEXT

Stores text data. For more detailed information about this data type, see the description on page TEXT data type.

No more than 195 columns of the same table can be declared as BYTE or TEXT data types. Unlike smart large objects, simple large objects do not support random access to the data. When you transfer a simple large object between a client application and the database server, you must transfer the entire BYTE or TEXT value. If the data cannot fit into memory, you must store the data value in an operating-system file and then retrieve it from that file.

The database server stores simple large objects in blobspaces. A blobspace is a logical storage area that contains one or more chunks that only store BYTE and TEXT data. For information about how to define blobspaces, see your HCL OneDB Administrator's Guide.