Mysql 1071 Specified key was too long
in Co-De with 4968 comments

Mysql 1071 Specified key was too long

in Co-De with 4968 comments

there is a index key limit

for single key limit:

the total key length limit is hard check.

for case
SomeCol varchar(1000)

if innoDB+utf8, it works use someCol to create index when large-prefix on (3*1000=3000)
if innoDB+utf8mb4, it not work as large than 3072(4*1000 = 4000)

other solutions
for index base on large colums, mysql offer prefix index, as only use a part of the colum value as index.

Responses
  1. You expressed it fantastically.
    Stomach Problems After Stopping Lexapro

    Reply
  2. cheap zithromax
    will propecia regrow hair

    Reply
  3. where to buy doxycycline

    Reply
  4. robaxin 75 mg sildenafil daily furosemide 20 mg tablet

    Reply
  5. metformin hydrochloride

    Reply
  6. Wonderful blog! I found it while surfing around on Yahoo
    News. Do you have any tips on how to get listed in Yahoo News?
    I've been trying for a while but I never seem
    to get there! Thank you

    Reply