Icinga latin1_general_ci is not valid for CHARACTER SET utf8

Despite all workarounds offered and multiple MySQL/MariaDB Server and Client configurations, after every upgrade I do the following:

Warning: make a backup of the directory content first!

cd /usr/share/icingaweb2/modules/monitoring/library/Monitoring/Backend/Ido
find ./ -type f -print0 | xargs -0 sed -i 's/ COLLATE latin1_general_ci//g' 

Done.