Collection binary representation
The database server supports the following collections
data types.
- LIST
- An ordered group of elements that can contain duplicate elements
- MULTISET
- An unordered group of elements that can contain duplicate elements
- SET
- An unordered group of elements that cannot contain duplicate elements
All collection data types use the same internal format
to store their values.
Tip: The internal format of a collection
data type is often referred to as its binary representation.
The DataBlade
API supports
the following SQL collection data types and data type structures:
- A collection structure (MI_COLLECTION) holds the binary representation of the collection.
- A collection descriptor (MI_COLL_DESC) provides information about the collection.