Setting connection collation in master for slave replication
Find all the Stored Routines; capture the ability to re-CREATE them.
Change the DEFAULT COLLATION for each DATABASE that had such routines.
DROP those routines.
Re-CREATE them.
SHOW CREATE PROCEDURE (etc) to verify that the collation is compatible with 5.7.