-
Problem report
-
Resolution: Fixed
-
Trivial
-
7.0.5
-
None
-
S24-W44/45
-
0.125
It seems appliance 7.0.5 is using utf8mb3:
mysql> show create database zabbix; +----------+---------------------------------------------------------------------------------------------------------------------------+ | Database | Create Database | +----------+---------------------------------------------------------------------------------------------------------------------------+ | zabbix | CREATE DATABASE `zabbix` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_bin */ /*!80016 DEFAULT ENCRYPTION='N' */ | +----------+---------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)mysql> mysql> show create table events\G *************************** 1. row *************************** Table: events Create Table: CREATE TABLE `events` ( `eventid` bigint unsigned NOT NULL, `source` int NOT NULL DEFAULT '0', `object` int NOT NULL DEFAULT '0', `objectid` bigint unsigned NOT NULL DEFAULT '0', `clock` int NOT NULL DEFAULT '0', `value` int NOT NULL DEFAULT '0', `acknowledged` int NOT NULL DEFAULT '0', `ns` int NOT NULL DEFAULT '0', `name` varchar(2048) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `severity` int NOT NULL DEFAULT '0', PRIMARY KEY (`eventid`), KEY `events_1` (`source`,`object`,`objectid`,`clock`), KEY `events_2` (`source`,`object`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin 1 row in set (0.01 sec)
The instructions for https://www.zabbix.com/download page suggest using the character set utf8mb4.