Working with MariaDB,
It's only working if I change in the Advanced settings the CharSet under Data Sources to utf8.
any idea how to make it work by default?
like making the necessary changes on the MySQL server and not on the client side.
I'm not a MariaDB expert but this could help: