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.