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
33849	Like statement is not case-sensitive in SQLite backend	Ali	nobody	"**Like** statement is not **case-sensitive** in SQLite backend.
I know that was mentioned in the documentation, but I think the **Glob** statement may solve it or the alternative statements for ''Like'',
the ''contains'' and ''icontains'' lookup has the same behavior because using the Like statement in the query, like this :
{{{
 ""SELECT ### FROM #### WHERE ### LIKE %####%""
}}}
but we can change it to this :
{{{
""SELECT ### FROM #### WHERE ### GLOB *####*""
}}}
for **contains** lookup in the SQLite backend, because the Glob statement is case-sensitive,the **Regex** statement also its a candidate"	Bug	closed	Database layer (models, ORM)		Normal	duplicate	Sqlite __contains __icontains	Like statement is not case-sensitive in SQLite backend	Unreviewed	0	0	0	0	0	0