mardi 22 mars 2016

How to create a collation in SQLite in an Android app?

I am trying to emulate following statements in my Android App:

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);
} {}

Refer commit in SQLite code base: http://ift.tt/1NDQBJL

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?

Related question: Android: Custom collation in SQLite

Aucun commentaire:

Enregistrer un commentaire