Question about max_string_size in Oracle 19c with client 12.1
Our customer recently upgraded their Oracle DB server from 12c Enterprise Edition 12.1.0.2.0 to 19c Enterprise Edition Release 19.0.0.0.0 - Production 19.6.0.0.0.
Customer claims that they do not use CDB/PDB or RAC.
Customer uses Oracle client v12.1.0.2.0. The customer claims their MAX_STRING_SIZE is STANDARD.
However, when our application calls OraOCIAttrGet() with attrtype type of OCI_ATTR_VARTYPE_MAXLEN_COMPAT, the call returns OCI_ATTR_MAXLEN_COMPAT_EXTENDED.
Customer INSISTS that their MAX_STRING_SIZE is STANDARD.
Is it possible that the use of Oracle client v12.1 with Oracle server v19.0 could cause an incorrect value for OCI_ATTR_MAXLEN_COMPAT to be returned?