Django aggregation escapes unicode strings?

Question

I tried to use aggregation on a database with unicode texts and it showed unicode object with unicode characters encoded another time. What can I do to show the unicode text after aggregation?

>>> from apps.person.models import Person
>>> from django.db.models import Min
>>> for p in Person.objects.all()[:1]: print(p.full_name)
...
15 чоловік
>>> Person.objects.aggregate(Min('full_name'))
{'full_name__min': u'15 \u0447\u043e\u043b\u043e\u0432\u0456\u043a'}

score 0 · Accepted Answer · answered Mar 10 '15 at 11:00

There's nothing specific to aggregation here. In the first line, you are calling print, but in the second you are just letting the shell output the result of the aggregate call, which always uses the repr format. This would work:

result = Person.objects.aggregate(Min('full_name'))
print result['full_name__min']

Django aggregation escapes unicode strings?

1 Answers1