Mysql ends support for custom sorting (User defined collations are deprecated and will be removed in a future release). However, the official Slovak classification utf8mb4_slovak_ci does not work correctly. It sorts the characters ä, č, ô, š, ž wrongly. How do I achieve the correct sorting without the ability to define my own?

Thank you.

I don’t know how else to fix the standard and bad collation, except to define my own collation.