UseArraySupport
This property specifies whether the connector supports getting the ResultSet data as an array.
1
: The connector returns ResultSet data as an array.0
: The connector returns ResultSet as VARCHAR.
The connector makes the following assumptions when returning the ResultSet as an array:
- The array columns are always of type
Array<String>
. - The array column data in the result set start and end with bracket characters (
[
and]
), and the array elements are delimited by commas (,
).
This means that multidimensional arrays or array elements that contain commas in their values are not parsed correctly.
Default Value | Data Type | Required |
---|---|---|
1 |
Integer |
No |