Search & Sort with _lower fields

We will soon be adding 4 fields to the data to improve performance for searching.  They can also be an effective for sorting.

character.name.first_loweritem.displayname_lowerguild.name_lowerspell.name_lower

These will contain a lowercase equivalent of the data in the following fields (respectively)...

character.name.firstitem.displaynameguild.namespell.name

These fields can be used so that you don't have to perform a case-insentive function on the query. These fields will also be indexed so that your "begins with" searches should be blindingly fast.

So, instead of...

census.daybreakgames.com/json/get/eq2/character/?name.first=i/^blah/

...you should use...

census.daybreakgames.com/json/get/eq2/character/?name.first_lower=^blah

We are populating this field on the database so that it will be available.  Until it is, you shouldn't rely on the field.  The process is about 10% complete.  I'd estimate that this will be ready to use in 2 hours.

-dan