[Teradata Database] [TeraJDBC 16.20.00.12] [Error 6706] [SQLState HY000] The string contains an u...

Hello,

I am trying to insert data into Teradata Database, using DB Writer node. The text in the data includes some symbols like ™, č etc.

I am using the UTF-8 encoding for the database connection, as well as for the input excel file.

jdbc:teradata://192.168.1.1/DATABASE=DB_NAME,CHARSET=UTF8

I get the following error:

[Teradata Database] [TeraJDBC 16.20.00.12] [Error 6706] [SQLState HY000] The string contains an untranslatable character.

However, if I use CHARSET=ASCII, i don’t get an error, but these characters are replaced by ‘?’

Thank you!

Nauman