CODEWITHSUNDEEP
mysql
kattaprasanth
kattaprasanth

Reputation: 35

max key length is 1000 bytes in mysql workbench

when i am running jboss using mysqlworkbench in RHEL 6 .i am getting this error max key length is 1000 bytes .how to change the utf-8 charaterset to latin-1 in mysqlworkbench.

Upvotes: 0

Views: 670

Answers (1)

dma_k
dma_k

Reputation: 10639

As written in documentation for MySQL server you may specify the character set on database level (create database DD default character set latin1), table level (create table TT (...) default character set latin1) or column level (FF varchar(50) character set latin1 not null). This will allow you to use more characters in unique index, but cannot overcome MySQL limitation.

Upvotes: 1

Related Questions