Hi Corona lovers,
I have a sqlite database, and i need to order by a column that haves some words starting by a accented character. These items are being ordered wrong, they are appearing on the end of the results.
I saw some tips there :
where someone suggest :
ORDER BY <field> COLLATE LOCALIZED
or even :
ORDER BY <field> COLLATE UNICODE
But i get this error :
No such collation sequence: (localized / unicode)
Do you have any ideas or suggestion ?
In my case i can maybe write some exceptions commands but of course its clumsy.
Thank you in advance guys