MySQL Incompatibility: unique_together constraint on BLOB

[matthewwithanm]

The Post model contains a unique_together constraint with includes the (BLOB) guid field, making it MySQL incompatible. Running syncdb results in the following error:

_mysql_exceptions.OperationalError: (1170, "BLOB/TEXT column 'text' used in key specification without a key length")

I was going to submit a patch, but I'm not sure how you want to handle this. Clearly, the easiest thing would be to just remove the constraint, however another option is to store a hash of the guid and use that for the unique_together tuple instead.

Here's some more information about this particular limitation.

[kouroshshafi]

when I want to migrate from my own initially schemma I have the same problem.

[kouroshshafi]

A work-around is to use CharField instead of TextField on guid.