-
Change Request
-
Resolution: Fixed
-
Trivial
-
4.0.41rc1
-
Sprint 88 (May 2022), Sprint 89 (Jun 2022)
-
0.25
Start from MySQL 8.0.29 version changed charset support
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-29.html
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
define('ZBX_DB_DEFAULT_CHARSET', 'UTF8');
define('ZBX_DB_MYSQL_DEFAULT_COLLATION', 'utf8_bin');
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"
- Closed