title: android sqlite index on null column
body: <p>I have a table and would like to create 3 columns unique index. The problem is that one of column can have null values. As you probably know sqlite treats those values in special way and if we have</p>
  
  <pre><code>row1: A, B, null
  row2: A, B, null
  </code></pre>
  
  <p>It will be accepted (even if I created unique index on A, B, C).</p>
  
  <p>The question is if there is any trick which could treat null as the same value as all others (ex. null is zero) and in the case above, second row wouldn't be accepted as violating the rules.</p>
  
  <p>THanks in advance for help.</p>