SQL Lite ordering accented characters

Other
#1

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 :

https://stackoverflow.com/questions/19906086/problems-ordering-sqlite-by-a-column-with-accented-characters-Á

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 :slight_smile:

#2

Well, the fastest workaround that i found is use 2 dedicated fields in my database : one for sorting without accents and the other one to display accents :slight_smile:

#3

Well, the fastest workaround that i found is use 2 dedicated fields in my database : one for sorting without accents and the other one to display accents :slight_smile: