Django Unicode und MySQL

http://www.mail-archive.com/django-users@googlegroups.com/msg58966.html u, 18 Sep 2008 08:12:48 -0700

Since you say you are using UTF8_BIN collation on MySQL, be sure to read:

http://docs.djangoproject.com/en/dev/ref/databases/#collation-settings

When you specify a binary collation in MySQL, your application code has to take on the responsibility of transforming bytestrings returned by the database to unicode objects. As noted in the docs, you can use django.utils.encoding.smart_unicode() to do this. You should use this in your unicode method to coerce the bytestrings coming from the database to unicode. Failure to do this results in many problems like what you have been reporting, as the admin app relies on the model's unicode method to display/log information about objects.