Wrong collation for ids.

[Flo4604]

Our generated IDs, e.g., from the UID package, have a given entropy due to the fact that there are lower and uppercase characters in the ID.

These do not hold up, as our database uses the utf8mb4_0900_ai_ci collation, with ci standing for case-insensitive.

This means our IDs are less unique than they should be, as, for example, api_4qD329Bz36dAo1uY is the same as api_4qd329bz36dao1Uy.

Our ids need a different collation, the idea would be to only change this for all ids except auditlog ones.

First it has to be checked if this is possible or if we need to change all collations

Error 1267 (HY000): Illegal mix of collations (utf8mb4_0900_as_cs,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

[linear]

ENG-2116