PHP

General error: 1709 Index column size too large. The maximum column size is 767 bytes.

//Laravel located in config/database.php
//replace this one in mysql
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
            
//to this one
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',

index column size too large. the maximum column size is 767 bytes. mysql

set global innodb_file_format = BARRACUDA;
set global innodb_large_prefix = ON;
create table test (........) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;