0

I am getting this data from a DB table and the encoding does not seem to be working.

  • é
  • é é
  • Ú é é éé
  • î éé
  • é
  • ç é

I tried changing the encoding of the file in Sublime but that wouldn't work. I also tried a few encode/decode combinations I found here but nothing is resolving it.

I am using Teradata.

Any idea how to figure out what the encoding is and how to set it to something readable? Preferably in Latin alphabet.

Don Code
  • 781
  • 3
  • 12
  • 25
  • Which driver are you using to connect to Teradata? Teradata SQL Driver for Python (`teradatasql`)? It may also depend on how the data was loaded. Maybe use the Teradata `CHAR2HEXINT` function to help figure out what data is actually stored, as a first step. – Fred Mar 10 '21 at 00:41
  • Is the data coming this way from a Teradata table? If So, what is the character set for the table? – Andrew Mar 10 '21 at 15:17

1 Answers1

0

I think that you should tell to MySQL that the connection must be made in UTF-8. You can check this 2 answers:
first answer
second answer

Mario Khoury
  • 372
  • 1
  • 7