A collection in text representation
When the control mode of the query data is text representation, the mi_value() or mi_value_by_name() function returns a value status of MI_NORMAL_VALUE for a collection column. The value buffer contains the text representation of the column.
For example, suppose that a query selects the set_col column,
which is defined as the following code fragment shows.
CREATE TABLE table1
(
....
set_col SET(INTEGER NOT NULL),
...
)If the set_col column contains a SET collection
with the values of
3, 5, and 7,
the value buffer contains the following string after mi_value() or mi_value_by_name() executes: "SET{3 ,5 ,7 }"