Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Mysql connection with utf8 encoding

MRAdam
Level 1
Mysql connection with utf8 encoding

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?

0 Kudos
1 Reply
MatiasL
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

0 Kudos