OData and case sensitivity

Question

I was messing around with OData and realized that URIs are case sensitive .... / Northwind.svc / Products! = ... / Northwind.svc / products Is this done on purpose? is there any way to make case insensitive?

Answer 1

The recommended solution is to either use the supported OData toupper or tolower functions to solve case sensitivity problems (using the filter$ command) and get a complete set of results.

I wrote a short post explaining this in a bit more detail:
Working with case sensitivity in OData

Answer 2

Here is an example: / people? $ filter = tolower (Name) eq tolower ('jAmes') - this will return you all people with the name "James" (case insensitive, maybe "JAMES", "james", "JamES", etc. I hope it will help