ScottF
February 13, 2023, 7:58pm
2
Hi @gabrielfs2 -
This sounds like an encoding issue. You might need to make apply some additional settings in the DB Connector to apply the correct encoding. Here are a few other forum topics dealing with a similar issue:
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…
Hi,
There is a problem with mysql character encoding. I changed the knime.ini file with the addition of Dfile.encoding=UTF8_turkish_ci (and tried all other encoding options as well) but database writer gives a connection error. Whenever I remove the added line from .ini file writer works but with encoding problem of course.
Is there any reason for this behavior of the database writer node?
What type of database are you trying to connect to?