Sprint 88 (May 2022), Sprint 89 (Jun 2022)
Start from MySQL 8.0.29 version changed charset support
Important Note: The server now uses utf8mb3 rather than utf8 in the following cases:
- In the output of SHOW SQL statements (SHOW CREATE TABLE, SHOW CREATE VIEW, SHOW CREATE DATABASE)
- When reporting invalid strings.
Zabbix 4.0 supports only this charset:
// Default db and field character set
Steps to reproduce:
- Install MySQL 8.0.29+ version
- Create database
create database zabbix character set utf8 collate utf8_bin;
- Connect to database in user interface
Result: Cannot connect to the database. Incorrect default charset for Zabbix database: "utf8mb3" instead "UTF8".
Expected result: need to add utf8mb3 support
- depends on
ZBX-21301 Error message cannot set MySQL character to "utf8"