Zabbix hostname is case sensitive

[asteroidyorkton]

I have the hostname as UPPER CASE for hostnames, but the agent log says no host found for my_host_name since they're in lower case.

Zabbix 3.0
My hosts.host column is uft8_bin.
host` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'utf8_bin',


At the moment i use ServerActive for Auto-Registration, but i'd be testing active checks soon. I think it'll create duplicate hosts (lower case hosts) separately if I have added a Upper case hostname already.
Can I change my hosts.table to case insensitive? Or should I re-create Zabbix DB as case insensitive? For just auto-registration, I think just the hosts table would be enough?

Also looks like if the hostname gets changed, the OLD name doesn't get changed in zabbix, rather the new name will get registered and I'll have to delete the old one manually.
Maybe one of the reason why we still can't get hostnames added automatically, instead IP becomes the hostname unless dns record is setup?

I don't use Hostname in the config, rather HostnameItem will fetch the hostname.

[asteroidyorkton]

I have changed it to 'utf8_general_ci'. It is a workaround.

It would not be a problem for zabbix in any way right? Almost all queries use id's.

host` VARCHAR(128) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',