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
25482	Field lookup istartswith not showing results in django 1.8.4 with mysql 5.5.44	Deepinder Singh	nobody	"According to documentation istartswith is Case-insensitive starts-with.

So following query should return results for names starting with keyword '''""wash""''':


{{{
>>> cities = City.objects.filter(name__istartswith=""wash"")
}}}

But what happens in actual is I am geting results only while using keyword '''""Wash""''':


{{{
>>> cities = City.objects.filter(name__istartswith=""wash"")
>>> cities
[]
>>> cities = City.objects.filter(name__istartswith=""Wash"")
>>> cities
[<City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington>, <City: Washington Court House>, <City: Washington Terrace>, <City: Washington, D.C.>, <City: Washingtonville>, <City: Washougal>]
}}}"	Bug	closed	Uncategorized	1.8	Normal	needsinfo	istartswith		Unreviewed	0	0	0	0	0	0