0

I am using the Teradatasql library to download data into a CSV file, using:

sql="{fn teradata_write_csv("+destination_path+")}SELECT DISTINCT..."

How do I determine (or specify) what the file encoding is? Is there a default encoding, or does it use the encoding of the table? (There are multiple tables which may have different encodings)

According to the filesystem on Ubuntu the file is ASCII, according to Windows it is ANSI, but in both cases the file contains incorrect characters. When parsing the file in python I get:

UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 5061: ordinal not in range(128)
Wige
  • 3,788
  • 8
  • 37
  • 58

0 Answers0