Android Question [SOLVED] Strange order by in sqlite

[yfleury]

All all, I fill a list with content of DB

dim listItem as list
listItem.initialize
dim cursor1 as Cursor
cursor1=Stater.sql.ExecQuery("select * from table order by Name")
for x=0 to cursor1.RowCount-1
    curcor1.Position=x
    listItem.Add(curseur.GetString("Name"))
Next

Spoiler: My db content this in that order

apple
Zoro
Google
tomato
zerox

Spoiler: The output of query

Google
Zoro
apple
tomato
zerox

It is ok that order by query run upper case first and lower case after?

 

[Mahares]

It is ok that order by query run upper case first and lower case after?

Use this syntax:
"select * from table order by Name COLLATE NOCASE"

 

[yfleury]

@Mahares you are so fast... Thank you
I just find that myself in
https://www.sqlite.org/datatype3.html#comparisons
at section
7.2. Collation Sequence Examples