Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-25434

Zabbix appliance 7.0 CHARSET utf8mb3 or utf8mb4

XMLWordPrintable

    • 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.

            yurii Jurijs Klopovskis
            aigars.kadikis Aigars Kadikis
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: