SQLSTATE[42000]: Syntax error or access violation: 1253 COLL

时间:2022-03-05 03:55:52

SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION ‘utf8mb4_unicode_ci‘ is not valid for CHARACTER SET ‘binary‘

SQLSTATE[42000]: Syntax error or access violation: 1253 COLL

 

 

对数据表更改,然后执行数据迁移命令php artisan migrate,之后报错如下:

  SQLSTATE[42000]: Syntax error or access violation: 1253 COLL

 

 

 解决办法:

SQLSTATE[42000]: Syntax error or access violation: 1253 COLL

 

 参考:https://www.hellojava.com/a/68286.html