Writing Greek characters to a MySql database

CloverDX Platform
1

I am unable to see Greek characters in a MySql database table after populating the table using the DBOutputTable writer. I’m reading in an Excel spreadsheet, using the Reformat transformer and then using the writer. When I enable debug, between Reformat and DBOutput and view the data, I see the Greek characters. However once written to the database, I just seen ???s. I believe I have all the appropriate options set to UTF-8, but I can’t seem to get it to work. If I populate the table field directly with Greek characters, it works fine. It’s just in the DBOutput where there seems to be a problem. Perhaps I’m missing one little piece somewhere.
Any help would be appreciated.

Thanks!

2

Hello, svyates,

Please, try DB connection with URL similar to this:

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

With this URL, everything works fine on my side. So I hope it helps you also. But let me know, if this is not helpful in your case.

Best regards,

3

Thank you, Lubos!!! It’s working fine now!

Cheers,

Steve