Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

OData and case sensitivity

I've been messing with the OData and realized that URIs are case sensitive. .../Northwind.svc/Products != .../Northwind.svc/products Is this done on purpose? is there a way to make it case insensitive?

like image 824
user323307 Avatar asked Nov 13 '10 02:11

user323307


People also ask

Is OData case sensitive?

OData API filter value which you are selecting for $FILTER parameter is always case sensitive.

What is $select in OData?

The $select option specifies a subset of properties to include in the response body. For example, to get only the name and price of each product, use the following query: Console Copy. GET http://localhost/odata/Products?$select=Price,Name.

What are some of the things that an OData service contains?

A URL used by an OData service has at most three significant parts: the service root URL, resource path and query options.


1 Answers

The recommended solution is to either use the supported OData functions toupper or tolower to work out the case sensitivity issues (when using a filter$ command) and get the full result set.

I wrote a brief post explaining this a bit further in detail:
Dealing With Case Sensitivity in OData

like image 82
atconway Avatar answered Sep 22 '22 04:09

atconway