Home » Tables » Unsupported Charset Or Collation For Tables Acknowledges Actions

Unsupported Charset Or Collation For Tables Acknowledges Actions

Unsupported charset or collation for tables warning displayed on System information.

Log In.

Export.

XML Word Printable.

Details.

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.

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.

0.

5# : [[email protected] ~]# cat /etc/redhat-release CentOS linux release 7.

2.

1511 (Core) [[email protected] ~]# uname -r 3.

10.

0-327.

el7.

x86_64 [[email protected] ~]# [[email protected] ~]# ifconfig eno16777736 eno16777736: flags=4163 mtu 1500 inet #, Zabbix supports only “utf8_bin” collation.

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 unsupported charset or collation for tables acknowledges actions