title: SQLite - turn-off case sensitivity on whole database
body: <p>can i turn off case sensitivity for whole database, means all the columns of all the tables ?</p>
  
  <p>what happen if i have already created the database?</p>
  
  <p>do i have to do it manually for all the columns setting <code>COLLATE</code> to <code>NOCASE</code>?</p>
  
  <p>i have tried <code>NOCASE</code> in several queries, like following</p>
  
  <pre><code>select * from ...table  COLLATE NOCASE
  </code></pre>
  
  <p>but what if me or some other new person forgot to use <code>NOCASE</code>
  I am tired of making every column NOCASE while creating tables.</p>