order by FIELD ASC

[sigster]

Hi need help with this Please

I am try to sort the sqlite listview
I use --> order by hverfi ASC

in the list I have word what start with Á that word are last in the list
but need to be the first

Regards
Sigster

 

[NJDude]

Have you tried using "COLLATE NOCASE"?

 

[sigster]

Yes COLLATE NOCASE don't work

 

[Mahares]

If it is last in the list and you want it to appear first, try using DESC instead.
order by hverfi DESC

 

[timo]

Did you try adding 'ListView1.clear' before quering the cursor?

 

[margret]

I believe the sort function uses the code value of the character to sort. The character you have listed in your first post is an extended character and will not show first unless you remove it from the list, then sort the list and then insert this character in the first position.

 

[NJDude]

Yes COLLATE NOCASE don't work

I haven't tested this but try: COLLATE BINARY