> php > SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT

php 小杰 5年前 (2018-09-19) 6812次浏览已收录 0个评论

除了数据库和表的属性都改为utf8mb4外，数据库的连接也要改，这个很容易遗漏：

‘mysql’ => [

‘driver’ => ‘mysql’,

‘host’ => env(‘DB_HOST’, ‘localhost’),

‘database’ => env(‘DB_DATABASE’, ‘forge’),

‘username’ => env(‘DB_USERNAME’, ‘forge’),

‘password’ => env(‘DB_PASSWORD’, ”),

‘charset’ => ‘utf8mb4’,

‘collation’ => ‘utf8mb4_unicode_ci’,

‘prefix’ => ”,

‘strict’ => false,