SQLite的查询不区分大小写字母顺序 [英] SQLite Query in non case sensitive alphabetical order

问题描述

我想要做的就是抓住按字母顺序排列的东西，而忽略了大写字母。

  db.rawQuery（选择+ catName +FROM+ tableName值+ORDER BY+ catName +ASC COLLATE NOCASE;，NULL）;
 

这是在code我在上面使用，但它总是给我一个SQLite异常说COLLATE是一个语法错误。

  

android.database.sqlite.SQLiteException：近分页：语法错误：在编制：SELECT艺人，TestTable的COLLATE NOCASE ASC

解决方案

COLLATE 的推移顺序方向前：

  db.rawQuery（选择+ catName
           +FROM+ tableName值
        +ORDER BY+ catName +COLLATE NOCASE ASC;，NULL）;
 

但你并不需要在 ASC - 这是默认的，所以你也可以同样使用：

  db.rawQuery（选择+ catName
            +FROM+ tableName值
        +ORDER BY+ catName +COLLATE NOCASE;，NULL）;
 

All I want to do is grab the stuff in alphabetical order and ignore the capital letters.

db.rawQuery("SELECT " + catName + " FROM "+tableName+" ORDER BY "+catName+" ASC COLLATE NOCASE;", null);

This is the code I'm using above, but it always gives me an SQLite exception saying that COLLATE is a syntax error.

android.database.sqlite.SQLiteException: near "COLLATE": syntax error: , while compiling: SELECT Artist FROM testTable COLLATE NOCASE ASC

解决方案

COLLATE goes before the order direction:

db.rawQuery("SELECT " + catName 
           + " FROM " +tableName 
        +" ORDER BY "+catName+" COLLATE NOCASE ASC;", null);

But you don't need the ASC -- that's the default so you could just as well use:

db.rawQuery("SELECT "+ catName 
            +" FROM "+ tableName 
        +" ORDER BY "+ catName +" COLLATE NOCASE;", null);

这篇关于SQLite的查询不区分大小写字母顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！