How to insert arabic data from bonitasoft to Mysql with MySQL connector?

1
0
-1

Hello, my name is SAIDI Mejdeddine, im newest in Bonitasoft.

So what i need is to insert data from bonitasoft to mysql database with MySQL connector.

The connection between MySQL and Bonitasoft is done, but the problem is the characters in MySQL is en crypted like this: (??? ??? ????).

I tried to fix the problem in MySQL. I changed the Collation to UTF-8_general_ci. when i insert a data from mysql everything is ok, but with bonitasoft it's the same problem.

BUT, when i create a process in bonitasoft, and i write the values in arabic and i show it in another form, it will be shown.

So my real problem is from Bonitasoft, just the insertion of data in MySQL DB.

Thank you very much.

1 answer

1
0
-1
This one is the BEST answer!

We need to change the URL in the MySQL Connector with:

jdbc:mysql://localhost:3306/DB_Name?useUnicode=true&characterEncoding=UTF-8

Notifications