Change the default mysql.collation key in config/database.php to something that your database version actually supports.
Mar 13, 2024
2
Level 1
Migration error in Laravel 11
Hello everyone. Please help me to fix this error. command :php artisan migrate Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1273 Unknown collation: 'utf8mb4_0900_ai_ci' (Connection: mysql, SQL: select table_name as name, (data_length + index_length) as size, table_comment as comment, engine as engine, table_collation as collation from information_schema.tables where table_schema = 'store' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name)
Level 104
2 likes
Please or to participate in this conversation.