myslq problems with graphical characters(Non ASCII characters)

[alvinstarr]

I get the following error on zabbix

201:20191025:143752.888 [Z3005] query failed: [1366] Incorrect string value: '\xE2\x94\x94\xE2\x94\x80...' for column 'value' at row 1 [insert into history_str (itemid,clock,ns,value) values (391012,1572028672,559058877,'can`t get indices stats from Elasticsearch https://127.0.0.1:9201
this appears to be caused by the leading characters on:

└─ Get https://127.0.0.1:9201/_cluster/health: dial tcp 127.0.0.1:9201: connect: connection refused

A simple fix is to add "| cat -v" to the zabbix conf to filter out the non-ascii characters.