Special characters when extracting data from database

[gabrielfs2]

Hello everyone

When trying to extract data from my database, some special characters have wrong symbols, but my database is correct, is there any configuration that I can perform?

[ScottF]

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:

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

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…

mysql character encoding problem

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?