解决Laravel错误1071 Specified key was too long的多种方法
If you are using MariaDB or an older version of MySQL, you need to place this code in your AppServiceProvider.php:
use Illuminate\Support\Facades\Schema; public function boot() { Schema::defaultStringLength(191); }
Inside config/database.php
, replace this line for mysql
'engine' => null',
with
'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',
Instead of setting a limit on your string lenght.Change database.php which is in config folder where it says
'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci',
I changed these to
'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',