mysql character encoding problem

KNIME Analytics Platform
1

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?

2

Problem solved. sql url requires a short code addition at the end. For others who may experience such a problem, you can use the following :

jdbc:mysql://<host>:<port>/<database_name>?useUnicode=true&characterEncoding=utf8

 

Thanks.

 

Bora

1 Like