title: Delphi TDataSet filter case insensitive not working
body: <p>I have an application with lots of datasets created at run-time. Some of this datasets are filtered. As filterOptions I've set foCaseInsensitive</p>
  
  <pre><code>dataset.FilterOptions := [foCaseInsensitive];
  </code></pre>
  
  <p>that means that '<a href="http://docwiki.embarcadero.com/RADStudio/XE2/en/Setting_Filter_Options" rel="nofollow noreferrer">foCaseInsensitive  - Ignore case when comparing strings.</a> ' according to Delphi help.</p>
  
  <p>The <code>dataset.filter</code> is changed on user input. </p>
  
  <p>At begging it shows all values:</p>
  
  <p><img src="https://i.stack.imgur.com/t8Iki.jpg" alt="enter image description here"></p>
  
  <p>when user type something is changed:</p>
  
  <p><img src="https://i.stack.imgur.com/ZXfwh.jpg" alt="enter image description here"></p>
  
  <p>The problem is that when I'm typing the last character, it shows nothing</p>
  
  <p><img src="https://i.stack.imgur.com/SKsxc.jpg" alt="enter image description here"></p>
  
  <p>Problem does not appear when I'm typing on upper-case</p>
  
  <p><img src="https://i.stack.imgur.com/uRE2M.jpg" alt="enter image description here"></p>
  
  <p>how can I fix this, to show correct the values when user input is only in lower case?</p>
  
  <p>LE: the component is a standard <a href="http://docwiki.embarcadero.com/VCL/en/DB.TDataSet" rel="nofollow noreferrer">TDataSet</a> from Delphi. 
  Filter is assigned with 'Like %value_entered%'.</p>
  
  <p>LE1: I'm using a in-house component which has a DataSet property. After I'm setting the filter, I set the property Filtered to true. So, it is a TDataSet property on what I'm talking about.</p>