zabbix7.4 character set
2026-07-210、create database zabbixdb character set utf8mb4 collate utf8mb4_bin;
如果用了#DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
#mysql -uroot -e"CREATE DATABASE IF NOT EXISTS ${item}db"
#mysql -uroot -e"CREATE DATABASE IF NOT EXISTS ${item}db2 character set utf8 collate utf8_bin;"
1、right is:
mysql -h ${host} -u root -D mysql -e "SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'zabbixdb'"
+----------------------------+------------------------+
| DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME |
+----------------------------+------------------------+
| utf8mb4 | utf8mb4_bin |
+----------------------------+------------------------+
2、if not，U need alter all table
Alter TABLE acknowledges CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE actions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE alerts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE auditlog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE autoreg_host CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE changelog CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE conditions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE config_autoreg_tls CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE connector CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE connector_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_condition CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_condition_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_condition_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_condition_tagpair CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_condition_tagvalue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE corr_operation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE correlation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dashboard CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dashboard_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dashboard_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dashboard_usrgrp CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dbversion CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dchecks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dhosts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE drules CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE dservices CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE escalations CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE event_recovery CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE event_suppress CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE event_symptom CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE event_tag CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE expressions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE functions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE globalmacro CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE globalvars CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE graph_discovery CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE graph_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE graphs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE graphs_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE group_discovery CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE group_prototype CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE ha_node CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE hgset CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE hgset_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history_bin CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history_str CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history_text CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE history_uint CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Alter TABLE host_discovery CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;