id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux
9905 SQLite case-insensitive problem Eugene Mirotin Malcolm Tredinnick "It's known (stated in the [http://www.sqlite.org/faq.html#q18 SQLite FAQ]) that SQLite does not support Unicode LIKE, which leads to Django behaving different on different DBs (see [http://groups.google.com/group/django-users/browse_thread/thread/6489570cf206358e/20a20d59cd4c3478 corresponding conversation on the list]).[[BR]]
[[BR]]
It looks that it can be fixed in the following way:[[BR]]
- including the pre-compiled SqliteIcu libraries[[BR]]
- patching the DB code so that it loads extension when creating DB connection if the engine is 'sqlite'[[BR]]
[[BR]]
Unfortunately I'm noob to Python and still have not found the full solution (i.e. where do icu.c really lives in the SQLite code, what pysqlite method should be actually called, and what is the place in Django code where the DB conn is created)" closed Documentation 1.0 fixed SQLite, DB, case-insensitive Unreviewed 0 0 0 0 0 0