I am planning an upgrade of a legacy MySQL5.6 Database to MYSQL8.0.19 database.
All my testing has been successful but have one issue preventing me from going live.
By default in MYSQL5.6 the following statement would return true
SELECT 'a ' = 'a';
But in MySQL 8, it returns false.
I understand that this has to do with the default collation on the database.
But when I try change it to
ALTER DATABASE **** CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
This collation supports PAD SPACE, however it does not return the functionality back to how it was in 5.6
My issue is that there are a lot of stored procedures that rely on the old functionality and would take a long time to change it.