Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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;
 
PREVIOUS NEXT
Tagged: #index #column #size #maximum #column #size #mysql
ADD COMMENT
Topic
Name
7+6 =