带有大写和非大写首字母的Android订单sqlite表

Question

我查询sqlite数据库的某些表：

public Cursor showAllTables(){
        String mySql = " SELECT name FROM sqlite_master " + " WHERE type='table'             "
                + "   AND name LIKE 'PR_%' ORDER BY name";
        return ourDatabase.rawQuery(mySql, null);
    }

我得到了这个结果：

雪佛兰

• hyundai

• Maserati
• bugatti

我怎样才能在第一个字母是大写字母的情况下，单独订购清单呢？

Answer 1

您需要将COLLATE NOCASE添加到查询的末尾：

public Cursor showAllTables(){
        String mySql = " SELECT name FROM sqlite_master " + " WHERE type='table'             "
                + "   AND name LIKE 'PR_%' ORDER BY name COLLATE NOCASE";
        return ourDatabase.rawQuery(mySql, null);
    }

或者您可以重新创建表并将COLLATE NOCASE添加到列定义中。

Answer 2

你可以试试这个：

public Cursor showAllTables(){
    String mySql = " SELECT name FROM sqlite_master " + " WHERE type='table'             "
                    + "   AND name LIKE 'PR_%' ORDER BY lower(name)";
    return ourDatabase.rawQuery(mySql, null);
}

我只用较低的(名)换了名字。