Hi, 
I am creating a model, which is taking a description as text field. when I 
migrate I see the below error:
django.db.utils.OperationalError: (1170, "BLOB/TEXT column 'Description' used 
in key specification without a key length")

ON further research I came to know that its some limitation with MySQL. I am 
using MYSQL for my dev. Below is the link that describes the issue.
MySQL error: key specification without a key length

| 
| 
| 
|  |  |

 |

 |
| 
|  | 
MySQL error: key specification without a key length

I have a table with a primary key that is a varchar(255). Some cases have 
arisen where 255 characters isn't enou...
 |

 |

 |


So what am I suppose to use if not TextField? I have tried CharField, that 
doesn't work either. Below is the model details:
class OnlineShop(models.Model):
    Product_name = models.CharField(max_length=100, unique=True)
    Price = models.IntegerField()
    Slug = models.SlugField(max_length=250, unique=True)
    Description = models.TextField()
    Curr_Time = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return '{}'.format(self.Product_name)



Regards,
Amitesh Sahay91-750 797 8619

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/1073924601.858407.1582555396348%40mail.yahoo.com.

Reply via email to