Django - MySQL (1170, "BLOB/TEXT column 'my_column' used in key specification without a key length

Asked Nov 29 '22 at 10:44

Active Dec 01 '22 at 09:05

Viewed 194 times

I've updated the Django model field from CharField to TextField.

I got the below error while applying migrations in MySQL.

django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'my_column' used in key specification without a key length")

Django version: 2.2.2 Note: This column in included in unique_together in Meta.

Below answers not worked/ not related:

edited Dec 01 '22 at 09:05

asked Nov 29 '22 at 10:44

DilLip_Chowdary

please provide that model – Manoj Tolagekar Nov 29 '22 at 10:48
It does not really make sense to have a unique index on a text field or a text field be part of a unique index as text fields are supposed to store large amounts of text. – Shadow Nov 29 '22 at 10:57
Index created when it's CharField, it will be removed in next migration – DilLip_Chowdary Nov 29 '22 at 11:13

0 Answers0