Steps to reproduce:

1. Have an old Zabbix Database on MySQL or MariaDB from pre 3.0 era
2. Patch to 4.4.4 or higher
3. Try to repair according to:
   https://www.zabbix.com/documentation/current/manual/appendix/install/db_charset_coll
4. Use query from ZBX-17740 instead

Result:

See log file: 3_alter.sql

Trying to login failed. Wrong user name and password. I had to use a backup admin account, a rename my account to function again.

Then I tried to add a trigger, but it says template not found. I had to rename the template twice, first a dummy name and then back to it's original name.After that it worked.

I'm not sure I haven't even discovered every problem, yet.

Expected:
I know that the DB is now case-sensitive and this switch had to be done, but I have now a load of problems.

Did I do anything wrong, is this expected?