DB Writer for Chinese Characters into MariaDB

batch
#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

0 Likes
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.

0 Likes