title: SQllite Query with Lower and Special Characters
body: <p>I have a Sqllite query </p>
  
  <pre><code>SELECT * FROM m_table WHERE LOWER(fName) = LOWER('yui!"'':;/?')  AND account = '100'  ORDER BY fName  COLLATE NOCASE ASC  ;
  </code></pre>
  
  <p>Above returns 0 rows; But when I use the same as below , it Works</p>
  
  <pre><code>update m_table set fName = 'yui!"'':;/? renamed' where fname='yui!"'':;/?' AND account = '100'; 
  </code></pre>
  
  <p>Any clues ?</p>
  
  <p>PS: I am using LOWER to ignore case sensitive. I am using this via an android client. Hence
  I am also doing StringEscapeUtils.escapeSql("folderName")</p>