sqlalchemy-teradata icon indicating copy to clipboard operation
sqlalchemy-teradata copied to clipboard

Teradata tables that have different encodings

Open Jonathanpro opened this issue 4 years ago • 0 comments
trafficstars

Hello Everyone, I tried to load Teradata tables using pandas -> sqlalchemy -> sqlalchemy-teradata.

So far this worked and it still works for several tables. However if the table is not encoded in utf-8 but for example in Cp1252 I get the following error message utf-8' codec can't decode byte....

The error message references to teradata/tdodbc.py", line 142, in _outputStr return unicode(s.raw.partition(b'\00')[0], 'utf8')

Encoding seems to be hardcoded and cannot be changed via code.

Do you know how to fix that ?

Kind regards, Jonathan

Jonathanpro avatar Nov 11 '21 13:11 Jonathanpro