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 |