title: Azure Table Storage service 2.0 case sensitive filter
body: <p>How to perform case sensitive filter On Azure Table storage 2.0 ?  </p>
  
  <p>If i do this query<br>
  <code>TableQuery.GenerateFilterCondition("ShortUrl", QueryComparisons.Equal, "Abc");</code> </p>
  
  <p>It will returns 2 records with shortUrl "Abc" and "ABC"<br>
  The generated query show like this   </p>
  
  <pre><code>/devstoreaccount1/Articles?$filter=shortUrl%20eq%20%27Abc%27&amp;timeout=90
  </code></pre>
  
  <p>There is a solution for version 1.7 shown <a href="https://stackoverflow.com/questions/10703142/how-to-perform-a-case-sensitive-linq-query-in-azure">here</a> , but this is not applicable on version 2.0. I have checked  <a href="http://msdn.microsoft.com/en-us/library/windowsazure/ff683669.aspx" rel="nofollow noreferrer">DataService Documentation</a> and it is not mentioned there. </p>
  
  <p>Since Table storage queries based on OData Protocol, why it behaves different when comparing string values. I am sure the Odata "eq" operator is supposed to be case sensitive.<br>
  Check <a href="http://services.odata.org/ODataAPIExplorer/ODataAPIExplorer.html" rel="nofollow noreferrer">OData Api Explorer</a> with this query </p>
  
  <pre><code>http://services.odata.org/V3/OData/OData.svc/Products?$filter= Name eq 'Bread'
  </code></pre>
  
  <p>Then change it to bread.</p>