mysql - "Specified key was too long; max key length is 1000 bytes"

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

I can't create index on varchar(500).

MySQL: Specified key was too long; max key length is 1000 bytes

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

779 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T17:57:49+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

latin1 = 1 byte = 1 character
uft8 = 3 byte = 1 character
gbk = 2 byte = 1 character

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…