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