Hi, I am trying to use DB Writer to load an excel with chinese characters into MariaDB. I can see the chinese characters when I preview it with Excel Reader but when I use the DB Writer to load it into the MariaDB, it shows ??? In the DB. I did not use the MariaDB driver since I was able to connect to the MariaDB using MySql connector. Any help greatly appreciated
did you check if MariaDB provides storing chinese characters and how the database has to be configured to work with it? Are the characters in UTF format?
I would also try to use the own MariaDB driver, maybe it provides extra/different functionalities.
Yes. MariaDB provide storing chinese characters and I was able to load chinese characters with python script. However DB Writer in KNIME just couldn’t write chinese characters into MariaDB.