Laravel 5.4 migrate时报错: Specified key was too long error
来源:互联网 发布:淘宝电商怎么加盟代理 编辑:程序博客网 时间:2024/06/15 15:36
Laravel 5.4默认使用utf8mb4字符编码,而不是之前的utf8编码。因此运行php artisan migrate 会出现如下错误:
[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t oo long; max key length is 767 bytes (SQL: alter table `users` add unique ` users_name_unique`(`name`))
问题根源
MySql支持的utf8编码最大字符长度为3字节,如果遇到4字节的宽字符就会出现插入异常。三个字节UTF-8最大能编码的Unicode字符是0xffff,即Unicode中的基本多文种平面(BMP)。因而包括Emoji表情(Emoji是一种特殊的Unicode编码)在内的非基本多文种平面的Unicode字符都无法使用MySql的utf8字符集存储。
这也应该就是Laravel 5.4改用4字节长度的utf8mb4字符编码的原因之一。不过要注意的是,只有MySql 5.5.3版本以后才开始支持utf8mb4字符编码(查看版本:selection version();)。如果MySql版本过低,需要进行版本更新。
注:如果是从Laravel 5.3升级到Laravel 5.4,不需要对字符编码做切换。
解决问题
1 升级MySql版本到5.5.3以上。
2 手动配置迁移命令migrate生成的默认字符串长度,在AppServiceProvider中调用Schema::defaultStringLength方法来实现配置:
use Illuminate\Support\Facades\Schema; /*** Bootstrap any application services.** @return void*/public function boot(){ Schema::defaultStringLength(191);}
阅读全文
0 0
- Laravel 5.4 migrate时报错: Specified key was too long error
- Laravel 5.4 migrate时报错: Specified key was too long error
- Laravel 5.4 migrate时报错: Specified key was too long error
- Laravel 5.4 migrate时报错: Specified key was too long error
- Laravel migrate时报错: Syntax error or access violation: 1071 Specified key was too long
- laravel Specified key was too long 解决方案
- Hive创建表时报错,Specified key was too long; max key length is 767 bytes
- 解决springboot+jpa+hibernate启动时报错:MySQLSyntaxErrorException: Specified key was too long; max key lengt
- Specified key was too long
- Hive安装好之后创建表时报错MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
- Hive执行某些命令时报错Specified key was too long; max key length is 767 bytes
- laravel错误1071 Specified key was too long; max key length is 1000 bytes
- laravel错误1071 Specified key was too long; max key length is 1000 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- Spring MVC注解标签
- 数据结构学习实录二—算法的评价
- Spring IOC之bean的scope属性值:prototype与singleton
- 误删oracle redo01-03.log文件解决方法
- 45中JavaScript大全
- Laravel 5.4 migrate时报错: Specified key was too long error
- 23. OP-TEE中TA与CA执行流程-------tee-supplicant(TA请求具体请求的处理)
- 分块【线段树模板】
- Android7.0中文文档(API)--- DatePicker
- 【故障排查】DataNode进程占用大量CPU,导致服务器夯死
- 安装wamp出现VCRUNTIME140.DLL丢失错误
- 使用spring注入时出现 XXX is not writable or has an invalid setter method
- OpenGL ES 【Opaque 属性在 CAEAGLLayer 中的配置详解】
- QT PK Connect