AnsweredAssumed Answered

SQLColAttribute returns wrong SQL_DESC_DISPLAY_SIZE on random column sometimes

Question asked by jshen on Nov 6, 2016
Latest reply on Nov 16, 2016 by taylorsharpe

I am using FileMaker ODBC 32bit driver(15.00.06.00) to access FileMaker Server (14.0.4.412). The ODBC API: SQLColAttribute is used to retrieve each SQL_DESC_DISPLAY_SIZE of the columns of result set. The weird problem I found is that: for some columns, the value returned from the API is wrong in rare cases, the wrong display size is always 7, that results in the column data returned is truncated during the subsequent row-binding result set fetching ODBC API calls.

Outcomes