سلام من هنگامی که از این دستور در لاراول8(php artisan migrate)استفاده میکنم با این ارور مواجه میشم
Illuminate\Database\QueryException
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4' (SQL: select * from information_schema.tables where table_schema = jc and table_name = migrations and table_type = 'BASE TABLE')
at C:\xampp\htdocs\lara2\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
667▕ // If an exception occurs when attempting to run a query, we'll format the error
668▕ // message to include the bindings with SQL, which will make this exception a
669▕ // lot more helpful to the developer instead of just the database's errors.
670▕ catch (Exception $e) {
➜ 671▕ throw new QueryException(
672▕ $query, $this->prepareBindings($bindings), $e
673▕ );
674▕ }
675▕
}
675▕
1 C:\xampp\htdocs\lara2\vendor\laravel\framework\src\Illuminate\Database\Connectors\MySqlConnector.php:76
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for
CHARACTER SET 'utf8mb4'")
2 C:\xampp\htdocs\lara2\vendor\laravel\framework\src\Illuminate\Database\Connectors\MySqlConnector.php:76
PDO::prepare("set names 'utf8mb4' collate 'utf8_unicode_ci'")