ORM isn't finding Unicode names with special characters with MySQL and UTF8 tables

[mattdennewitz]

Django's ORM doesn't seem to be able to select records by a field w/ special characters in the criteria. For example: it's properly inserted a record who's unicode "name" property has a cedilla, but when looking up the record w/ the same unicode "name" variable it used to insert, the ORM raises DoesNotExist.

Im using MySQL 5 w/ UTF8 tables and unicode collation and Django svn rev. 7826 on OSX Leopard

[mattdennewitz]

These are the last two queries executed before the time of death:

Exception: [{'time': '0.001', 'sql': u'SELECT `entities_entity`.`id`, `entities_entity`.`name`, `entities_entity`.`is_active`, `entities_entity`.`created_date` FROM `entities_entity` WHERE `entities_entity`.`name` = BINARY Fran\xe7oiz Breut '}, {'time': '0.000', 'sql': u'INSERT INTO `entities_entity` (`name`, `is_active`, `created_date`) VALUES (Fran\xe7oiz Breut, True, 2008-07-02 14:49:52)'}]

[Jacob]

Django's got plenty of regression tests that ensure it works correctly with Unicode data (see tests/modeltests/basic just for a few), so this is likely something going on in your code. For example, if you're using Unicode literals in your code and haven't properly declared the source file's encoding you could get errors just like this.

I'm closing this ticket "worksforme" since Unicode data has worked in Django for many, many others. Please reopen with more details if you're convinced it's a Django bug, but please first look into what it could be in your code since that's probably where the problem lies.