How I can increase max key length to more than 767 bytes?
Asked by
Mikhail Gavrilov
CREATE TABLE `clients` (
`id_client` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`fullname` VARCHAR(700) DEFAULT NULL,
PRIMARY KEY (`id_client`)
) ENGINE=INNODB DEFAULT CHARSET=utf8
ALTER TABLE `clients`
ADD INDEX `fullname` (`fullname`(700));
Warning Code : 1071
Specified key was too long; max key length is 767 bytes
If I cannot do it with database setting can I fill bug report?
MariaDB 10.0.7
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- MariaDB Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Mikhail Gavrilov for more information if necessary.
To post a message you must log in.