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          }"