I try to access String Array field from Java code using JDBC. The result seem to show-up as a single indexed value with each array index value separated by
single quote (For ex: Array(“apple”, “orange”, “peaches”) would show-up as Array(“apple’orange’peaches”). But the datatype is Array (based on java.sql.Types — ARRAY/2003).
The same code works fine for Numeric Array values. I can confirm that the data is stored correctly in CDB too.