Mysql connection with utf8 encoding

[MRAdam]

i am connecting dataiku with a mysql connection, when i altered my database to be able to use utf8 encoding to support arabic language it didnt work and raised this error:

Job failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connectionProperties.characterEncoding=UTF-8' at line 1

can someone help me with this?

[MatiasL]

Hi @MRAdam ,

Firstly, could you please confirm which MySQL version do you actually have? Also which DSS version?

How did you exactly try to make MySQL handle UTF-8 encoding?

You should follow some steps as below (the MySQL step):

https://www.toptal.com/php/a-utf-8-primer-for-php-and-mysql

Looking forward to your feedback

Thank you