Android SQLite not Sorting

Question

Do you know what's wrong about my try of sorting the SQLite results?

Here it's how I do on Java (Android):

return database.query("tools", new String[] {"_id","title"}, null, null, null, null, "title Asc");

Believe, I already tried this:

SELECT _id, title FROM tools ORDER BY title ASC

But in both ways, the SQL result is sort by the field _id ASC!

Don't know what to do anymore.

Thanks

[[EDIT]]

I looked at my results and I guess what's going on.

_id          title
 1            test
 2            Ábc
 3            Abcd

title has special characteres

Your SQL query should be returning the data ordered by title. Something else would seem to be the problem. — Gordon Linoff
– Gordon Linoff, Commented Aug 24, 2014 at 14:06
Why do you think the result is wrong? How do you look at the results? — CL.
– CL., Commented Aug 24, 2014 at 14:07
@CL. the result is sorting by _id (_id is a incremental field). For example, the result is like this: 1 Test 2 Abc Where 1, 2 are the _id and Test, Abc the title. — Felipe M
– Felipe M, Commented Aug 24, 2014 at 14:12
@GordonLinoff unfortunately the result isn't sorting well, I do a while Log(result) and it's sorting by _id :( — Felipe M
– Felipe M, Commented Aug 24, 2014 at 14:14

Community · Accepted Answer · 2017-05-23 10:30:19Z

3

I got the error. My title field has accents.

Before:

SELECT _id, title FROM tools ORDER BY title ASC

After:

SELECT _id, title FROM tools ORDER BY title COLLATE UNICODE ASC

Note that "COLLATE UNICODE" ignores the current locale. The structure must be:

Order By COLUMN COLLATE UNICODE [ASC/DESC]

CommunityBot

11 silver badge

answered Aug 24, 2014 at 14:20

Felipe M

4591 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

@evanwong what essential parts do you have in mind? Does the query not count?

Now it is better. By the way, I didn't vote you down.