[rsyslog] how log non-ascii characters into mysql

[蔡超]

Hi,

  I want to record some non-ascii (e.g. UTF8) text using rsyslog. When the
message is written to file, it is recorded as I logged, so it can be decoded
and read well. But if the message is written to mysql, I can't decode it,
even through I have changed charset configurations of the mysql database,
tables and columns. What has happened before the messages were sent to
mysql?

Another problem, suppose I know the encodings of messages from all devices,
and I want to transform them into some uniform one before saving. How can I
achive it?

Best regards

Cai Chao