title: How to change the collation of sqlite3 database to sort case insensitively?
body: <p>I have a query for sqlite3 database which provides the sorted data. The data are sorted on the basis of a column which is a <code>varchar</code> column "Name". Now when I do the query </p>
  
  <pre><code>select * from tableNames Order by Name;
  </code></pre>
  
  <p>It provides the data like this.</p>
  
  <pre>
      Pen
      Stapler
      pencil
  </pre>
  
  <p>Means it is considering the case sensitive stuff. The way I want is as follows</p>
  
  <pre>
      Pen
      pencil
      Stapler
  </pre>
  
  <p>So what changes should I make in sqlite3 database for the necessary results?</p>
  
  <blockquote>
    <p>Related <a href="https://stackoverflow.com/questions/973541/how-to-set-sqlite3-to-be-case-insensitive-when-string-comparing">How to set Sqlite3 to be case insensitive when string comparing?</a></p>
  </blockquote>