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
Hi @wxchoy,
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.
Best,
Michael
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.
As I can’t reproduce this without a proper chinese source xml file: can you please upload such a example file with dummy datas or a sample workflow. I will try to reproduce it then again.
Thanks in advance, Best
Michael
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.