search

Teradata / PyTd

A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
MIT License
108 stars 43 forks source link

Teradata ODBC 16.20 - Bug in SQLColumns[W] ? #97

Open H-Eilat opened 6 years ago

H-Eilat commented 6 years ago

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 commented 6 years ago

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