title: How to create a collation in SQLite in an Android app?
body: <p>I am trying to emulate following statements in my Android App:</p>
  
  <pre><code>db collate {"""} [list string compare -nocase]
  
  do_execsql_test 6.5 {
    PRAGMA foreign_keys = ON;
    CREATE TABLE p1(a PRIMARY KEY COLLATE '"""');
    CREATE TABLE c1(x, y REFERENCES p1);
  } {}
  </code></pre>
  
  <p>Refer commit in SQLite code base: <a href="https://www.sqlite.org/src/info/eddc05e7bb31fae7" rel="nofollow noreferrer">https://www.sqlite.org/src/info/eddc05e7bb31fae7</a></p>
  
  <p>I am not sure about how to create a collation named """ as mentioned in above code. Is it even possible to do in an Android app?</p>
  
  <p>Related question: <a href="https://stackoverflow.com/questions/8128834/android-custom-collation-in-sqlite">Android: Custom collation in SQLite</a></p>