Teradata ODBC 16.20 - Bug in SQLColumns[W] ?

[H-Eilat]

I am in a process of elevating a project to 16.20. There is an existing code that implements metadata queries via ODBC SQLColumn API. It used to work fine in past TD ODBC versions. Under TD ODBC 16.20 it fails unconditionally. The scenario is rather simple. It is exemplified in the attached code. An SQLColumn result set for a given table is established correctly. The 1st fetch goes fine. The 2nd fetch fails while informing unclear message. I got the following: SQLSTATE = '22018' NATIVE ERROR = '40550' Message=[Teradata][Support] (40550) Invalid character value for cast specification. I think that I got some other exceptions while looking into it on subsequent attempts. Recall that under past TD ODBC versions this code worked perfectly fine.

Help will be appreciated.

/H APR_TD_OPR_1_odbc_certification.zip

[zandym]

I had encountered something similar with v16.20 and was able to resolve it by adding 'charset=utf8' in my connection string.