So I need some help With a simple workflow.
I have a workflow that extracts data from the API and inserts in a MariaDB database.
When i use the MySQL JDBC it takes a very long time to insert, but all the data are inserted in correctly.
In the other case, when i use the MariaDB JDBC the insertion is very fast, but i receive an error “Incorrect string value: '\xCC\xA7a\xCC”.
Would you guys know if this is a common problem? If yes, is there a solution that does not involve changing the database characterEncoding and collation settings? Is there something that i can set in the Database URL?
If you have any questions, please let me know.