The MEMO Data Type

The MEMO Data Type The MEMO Data Type

Description:

The MEMO data type provides storage for variable length and arbitrary format data. A MEMO field can contain either text or binary data.

There are two synonyms for the MEMO data type: CLOB and BLOB.

A CLOB (character large object) is specifically defined for text.
A BLOB (binary large object) is specifically defined for binary data.

A MEMO/CLOB/BLOB field cannot be a KEY.

A MEMO/CLOB/BLOB field can be in a TEMP table.

The maximum MEMO/CLOB/BLOB field size is 262,144 bytes.

In the data base, a MEMO field is represented by a 20 byte marker. The size of the marker is defined by the symbolic constant TBAPI_INTERNAL_MARKER_LENGTH in ddl_defs.h.

Data Base Definition Syntax

The DBD Data Declaration Syntax for a MEMO/CLOB/BLOB data item is:
         <fieldname> MEMO
         <fieldname> CLOB
         <fieldname> BLOB

A MEMO/CLOB/BLOB field cannot be a KEY.

A MEMO/CLOB/BLOB field can be in a TEMP table.

Record Description Syntax

The RD Record Description Syntax for a MEMO/CLOB/BLOB data item is:
         <fieldname> MEMO
         <fieldname> CLOB
         <fieldname> BLOB