sqlalchemy-teradata
sqlalchemy-teradata copied to clipboard
Teradata tables that have different encodings
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