ODBC Driver Returns Wrong Buffer_length Through SQLColumns() API
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version: 18.104.22.168
Information in this document applies to any platform.
and wrong BUFFER_LENGTH FOR all CHAR type columns, when using char semantics but
not for NVARCHAR2 column from a SYNONYM.
From the ODBC documentation:
COLUMN_SIZE : this column contains the maximum length in characters of the column
BUFFER_LENGTH : should return the number of bytes (like OCI_ATTR_DATA_SIZE)
When specifying VARCHAR2(100 CHAR) on a AL32UTF8 RDBMS, BUFFER_LENGTH is
reported as 100 on the base table which is wrong, and the synonym report the
correct 400 bytes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms