index column size too large. the maximum column size is 767 bytes
迅睿框架 更新 2022-09-22 12:10:24
ruiruler
ruiruler
本地Wampserver安装
通过test.php检测安装环境正常
但是在安装过程中出现index column size too large. the maximum column size is 767 bytes
![6@1~[]EY{310C}JN2OK5{(C](https://file.xunruicms.com/gwbbs/ueditor/image/202202/1645588292c800aa.png "6@1~[]EY{310C}JN2OK5{(C")
请问如何解决？
1. 对数据库进行设置
set global innodb_file_format = BARRACUDA
set global innodb_large_prefix = ON
注意: 在navicat中执行成功,不清楚重启数据库是否还有效
查看是否生效
show variables like 'character%';
show variables like 'collation_%';
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
2. 对脚本进行修改，添加ROW_FORMAT=DYNAMIC
create table test (........) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;