zabbix database format

[dave08]

Hello.
I'm using a zabbix 5.4.6 appliance and had been updating the database since previous versions. In the Dashboard I get: "Unsupported charset or collation for tables: dashboard_page, httptest_tag, item_tag, report, report_param, script_param, sysmaps_element_tag, token, valuemap, valuemap_mapping." even after entered the following command:
"alter database zabbix character set utf8 collate utf8_bin;"

Now my database list character_set_database is utf8mb3 (Instead of utf8mb4) and utfb8_bin as collation_database instead of previous "utf8mb4_0900_ai_ci";
Why do I get the error in the dashboard and why can't I set the character_set_database to utf8 instead of utfbmb3?

Thank you so much!
Regards
David

[dimir]

You need to alter the tables explicitly:

alter table dashboard_page convert to character set utf8 collate utf8_bin;

and others.

[dimir]

You need to alter the tables explicitly:

alter table dashboard_page convert to character set utf8 collate utf8_bin;

and others.

[dave08]

Thanks for the reply. No more alerts.
Hi hope I won't have any issues by cannot change the character_set_databse to utf8 instead of utf8mb3.