Mysql connection with utf8 encoding
![MRAdam](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar3.png)
MRAdam
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 2 ✭
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?
Answers
-
Matias Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 12 Dataiker
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