Unique key far too long unsig UTF-8

[yvandermeer]

Greetings,

I am using django 1.2.3 with python 2.6.6 and mysql 5.1.49.

When I run ./manage.py syncdb, I receive the following error:
_mysql_exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')

This is very likely caused by the line:
unique_together = ('domain', 'port', 'path', 'querykey')

The length of the four fields totals (with a utf-8 encoding) to more than 1000 bytes (100+4(8?)+250+255=609(613?)*3) (3 comes from this discussion: http://bugs.mysql.com/bug.php?id=6604)

---

• Bitbucket: https://bitbucket.org/yvandermeer/django-http-proxy/issue/7
• Originally reported by: MadeR
• Originally created at: 2010-12-20T18:00:45.562