title: How do I create a case sensitive query in Oracle forms?
body: <p>I have a block based on a table. If I enter "12345" in enter query mode, it creates a query with </p>
  
  <pre><code>WHERE my_field = '12345' 
  </code></pre>
  
  <p>If I enter "12345A", it goes</p>
  
  <pre><code>WHERE (upper(my_field) = '12345A' AND my_field like '12%')
  </code></pre>
  
  <p>which is bad, because my_field is indexed normally (not on upper(my_field)). I have tried toggling "Case restriction" attribute between mixed and upper, and "Case insensitive query" between yes and no, nothing seems to help. I also have a block level PRE-QUERY trigger (trigger starts with a RETURN; statement) set on override, so nothing should mess with the formation of the query, yet it still messes up.</p>
  
  <p>Any ideas on what else I could try?</p>
  
  <p>EDIT:</p>
  
  <p>There was an obscure function call within WHEN_NEW_FORM_INSTANCE trigger to some attached library that reset all trigger block's items to CASE_SENSITIVE_QUERY = TRUE. Never would have guessed.</p>