mariadb unknown collation: 'utf8mb4_0900_ai_ci'

Error Message:

The error message "unknown collation: 'utf8mb4_0900_ai_ci'" in MariaDB indicates that the specified collation is not recognized.

Solution:

To resolve this issue, you can change the collation to a recognized one, such as 'utf8mb4_general_ci'. You can do this by modifying the table's default collation or specifying the collation explicitly when creating or altering a table.

Example:

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Additional Information:

You can also check the available collations in your MariaDB instance using the following query:

SHOW COLLATION;

This will display a list of available collations that you can use for your tables.