mysql - How to force rsyslog ommysql use utf8? -
i'm using ommysql in rsyslog transfering data mysql
$modload ommysql local6.* :ommysql:localhost,syslog,rsyslog,1
but cyrilic data goes "·Ð¾Ð²Ð°Ð½Ð¸Ðµ иÑ�точнÐ" in database.
i think it's because ommysql doesn't set utf8 encoding , starts inserting @ once it's connected: http://s017.radikal.ru/i441/1606/e0/050cf30c495f.png
is way «set names utf8;» before inserting?
that should have said ование
, correct?
when trying use utf8/utf8mb4, if see mojibake, check following. discussion applies double encoding, not visible.
- the bytes stored need utf8-encoded.
- the connection when
inserting
,selecting
text needs specify utf8 or utf8mb4. - the column needs declared
character set utf8
(or utf8mb4). - html should start
<meta charset=utf-8>
.