Edit Question - KnowledgeHub

Title Body

I'm storing Unicode strings in a MySQL database with a Django web application. I can store Unicode data fine, but when querying, I find that é and e are treated as if they were the same character: In [1]: User.objects.filter(last_name='Jildén') Out[1]: [<User: Anders Jildén>] In [2]: User.objects.filter(last_name='Jilden') Out[2]: [<User: Anders Jildén>] This is also the case when using the MySQL shell directly: mysql> select last_name from auth_user where last_name = 'Jildén'; +-----------+ | last_name | +-----------+ | Jildén | +-----------+ 1 row in set (0.00 sec) mysql> select last_name from auth_user where last_name = 'Jilden'; +-----------+ | last_name | +-----------+ | Jildén | +-----------+ 1 row in set (0.01 sec) Here are the database charset settings: mysql> SHOW variables LIKE '%character_set%'; +--------------------------+------------------------------------------------------+ | Variable_name | Value | +--------------------------+------------------------------------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/local/Cellar/mysql/5.1.54/share/mysql/charsets/ | +--------------------------+------------------------------------------------------+ here's the table

Tags (comma-separated) Cancel