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?

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