How to fix / detect correct DB collation

[Jimmi08]

I still had issues with uploaded images in media manager.
New images should be first, but it wasn't .

Only now I found that it is because database collation - core supposes that order is "page", "_common_images", but starting with MySQL 8.0 or something like that, order is Underscore before alphabet

When I use
SHOW VARIABLES LIKE 'collation_server';
I got utf8mb4_0900_ai_ci

AI:
The utf8mb4_0900_ai_ci collation (introduced in MySQL 8.0) is accent-insensitive and case-insensitive, and it sorts underscores (_) before letters like p in ascending order. So, in your query ORDER BY media_category, media_id DESC, _common appears before page.

Developers expect _common to be last,

For me this query fails:
$query .= " ORDER BY media_category, media_id DESC"; // places the specified category before the _common categories.

I don't know if this is wampp issue or something that can be fixed during installation. On WAMPP I am letting e107 create a database.
When I change this manually in phpMyAdmin to something else, no change.