Unsupported charset or collation for tables warning displayed on System information.
XML Word Printable.
Type: Documentation task.
Check DB character set and collation on initial frontend setup page.
Closed; is duplicated by.
ZBXNEXT-5799 Provide instructions how to fix incorrect DB character set and collation.
04/04/2020 Unsupported charset or collation for tables: acknowledges, actions , alerts, application_discovery, application_prototype, applications,.
and then all the database tables #, [ZBX-17357] System information, Unsupported charset or collation for tables # ZABBIX SUPPORT; Zabbix 4.
6#utf8_bin #, #mysql#mysql # .
You need to execute a alter table statement for each table.
The statement would follow this form: ALTER TABLE tbl_name [[DEFAULT] CHARACTER SET charset _name] [COLLATE collation _name] Now to get all the tables in the database you would need to execute the following query:, zabbix3.
5# : [[email protected] ~]# cat /etc/redhat-release CentOS linux release 7.
1511 (Core) [[email protected] ~]# uname -r 3.
Database “zabbix” has default collation “utf8_general_ci” character set name or collation name that is not supported by Zabbix found in 384 column(s) of database “zabbix” only character set “utf8” and collation “utf8_bin” should be used in database