[BUG] Missing COLLATE for MySQL

[Leccho]

• Database type and version: MySQL

My database:

• InnoDB DEFAULT CHARSET = utf8mb4
• COLLATE = utf8mb4_general_ci

In any table, in Properties tab, the COLLATE display utf8mb4_0900_ai_ci and the list to update it is almost empty.

Looks like you've been using this to create it:
https://dev.mysql.com/doc/refman/8.4/en/charset-charsets.html

But this only shows the default COLLATE for a charset, the list is much more exaustive. you will find here all COLATTE for utf8mb4 in this example:
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html

I find myself having conflict with foreign key because of this problem.