DB Writer for Chinese Characters into MariaDB

KNIME Analytics Platform
#1

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

DB Writer - string data right truncation
#2

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

1 Like
#3

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.

#4

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

1 Like
#5

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.