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