В консоли mysql выполнить команду:
Код: Выделить всё
ELECT CONCAT( 'ALTER TABLE `', t.`TABLE_SCHEMA` , '`.`', t.`TABLE_NAME` , '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;' ) AS sqlcode
FROM `information_schema`.`TABLES` t
WHERE 1 AND t.`TABLE_SCHEMA` = 'zabbix'
ORDER BY 1 into outfile '/tmp/zabbix-conv.sql';Код: Выделить всё
ALTER TABLE `zabbix`.`acknowledges` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`actions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`alerts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`auditlog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`autoreg_host` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`changelog` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`conditions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`config_autoreg_tls` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`config` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`connector_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`connector` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`correlation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_condition_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_condition_tagpair` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_condition_tagvalue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_condition_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_condition` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`corr_operation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dashboard_page` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dashboard_user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dashboard_usrgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dashboard` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dbversion` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dchecks` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dhosts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`drules` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`dservices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`escalations` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`events` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`event_recovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`event_suppress` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`event_symptom` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`event_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`expressions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`functions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`globalmacro` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`globalvars` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`graphs_items` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`graphs` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`graph_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`graph_theme` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`group_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`group_prototype` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`ha_node` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hgset_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hgset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history_bin` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history_log` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history_str` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history_text` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history_uint` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hostmacro` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hosts_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hosts_templates` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hosts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_hgset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_inventory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_proxy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_rtdata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`host_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`housekeeper` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`hstgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httpstepitem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httpstep_field` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httpstep` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httptestitem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httptest_field` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httptest_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`httptest` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`icon_mapping` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`icon_map` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`ids` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`images` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`interface_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`interface_snmp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`interface` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`items` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_condition` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_parameter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_preproc` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_rtdata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_rtname` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`item_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_macro_path` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_condition` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_opdiscover` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_operation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_ophistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_opinventory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_opperiod` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_opseverity` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_opstatus` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_optag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_optemplate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override_optrends` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`lld_override` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`maintenances_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`maintenances_hosts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`maintenances_windows` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`maintenances` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`maintenance_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`media_type_message` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`media_type_param` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`media_type` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`media` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`mfa_totp_secret` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`mfa` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`module` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opcommand_grp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opcommand_hst` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opcommand` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opconditions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`operations` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opinventory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opmessage_grp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opmessage_usr` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`opmessage` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`optag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`optemplate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`permission` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`problem_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`problem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`profiles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_autoreg_host` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_dhistory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_group_rtdata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy_rtdata` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`proxy` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`regexps` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`report_param` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`report_user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`report_usrgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`report` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`rights` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`role_rule` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`role` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`scim_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`scripts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`script_param` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`services_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`services` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`service_alarms` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`service_problem_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`service_problem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`service_status_rule` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`service_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sla_excluded_downtime` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sla_schedule` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sla_service_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sla` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmaps_elements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmaps_element_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmaps_links` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmaps_link_triggers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmaps` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_element_trigger` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_element_url` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_shape` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_url` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`sysmap_usrgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`tag_filter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_acknowledge` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_check_now` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_close_problem` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_data` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_remote_command_result` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_remote_command` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task_result` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`task` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`timeperiods` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`token` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trends_uint` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trends` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`triggers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trigger_depends` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trigger_discovery` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trigger_queue` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`trigger_tag` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`ugset_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`ugset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory_idpgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory_ldap` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory_media` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory_saml` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory_usrgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`userdirectory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`users_groups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`user_scim_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`user_ugset` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`usrgrp` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`valuemap_mapping` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`valuemap` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`widget_field` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
ALTER TABLE `zabbix`.`widget` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
