不同的监视系统/设备和检查的返回值中可能有非ascii字符。对于这种情况,几乎所有的zabbix keys都包含一个额外的item key参数* * * *。 这个关键参数是可选的,但是如果返回的值不是UTF8编码,并且它包含非ascii字符,则应该指定它。否则,结果可能是出乎意料的和不可预测的。

在这种情况下,对不同数据库后台的行为描述如下。

MySQL

PostgreSQL

如果一个值在非UTF8编码中包含非ascii字符—这将导致一个失败的SQL查询(PGRES_FATAL_ERROR:编码的无效字节序列)和数据将不会被存储。会向zabbix_server.log中写入一个适当的警告消息.
Relevant for at least PostgreSQL version 9.1.3

5 Encoding of returned values

Zabbix server expects every returned text value in the UTF8 encoding. This is related to any type of checks: zabbix agent, ssh, telnet, etc.

A description of behavior with different database back-ends in such cases follows.

MySQL

If a value contains a non-ASCII character in non UTF8 encoding - this character and the following will be discarded when the database stores this value. No warning messages will be written to the zabbix_server.log.
Relevant for at least MySQL version 5.1.61

PostgreSQL