The Specifiedkeywastoolong; maxkeylengthis1000bytes error occurs when you set a unique index for a certain two fields in the database today.
The Specified key was too long; max key length is 1000 bytes error occurs when you set a unique index for a certain field in the database today.
After query, I know that the Mysql field is too long, so I just changed the length of the two fields.
When an Index is created, the length of the key calculated by the database is to accumulate the char length of all the fields used by the Index, and then multiply by the following proportion, the length of the key cannot exceed 1000:
Latin1 = 1 byte = 1 character
Uft8 = 3 byte = 1 character
Gbk = 2 byte = 1 character
For example, you can see more clearly. Take GBK as an example:
Create unique index 'unique _ record' ON reports ('report _ name', 'Report _ client', 'Report _ City ');
Report_name varchar (200), report_client varchar (200), report_city varchar (200)
(200 + 200 + 200) * 2 = 1200> 1000. If the report_city is changed to varchar (1071), the index can be created successfully.
If the table is a UTF8 character set, the index cannot be created.
