select concat("alter table ", table_schema, ".", table_name, " modify column ", column_name,
	" ", column_type, " character set utf8 collate utf8_bin",
	case
		when column_default is null then ""
		else concat(" default """, column_default, """ ")
	end,
	case
		when is_nullable = 'no' then " not null "
		else ""
	end,
	";")
from information_schema.columns
where table_schema = 'zabbix' 
	and ( collation_name != 'utf8_bin' OR character_set_name != 'utf8' );