mercredi 28 janvier 2015

How to use multiple collators on sql query

I'm doing query on Adroid SQLite local Database. My Database uses collations.



... ORDER BY name COLLATE LOCALIZED


I found out that the search has to be case insensitive. Example:



... ORDER BY name COLLATE NOCASE


How can i use both collators together?


I can also manipulate the incoming data itself if necessary. But I would like to use SQLite built-in fuctions.


Aucun commentaire:

Enregistrer un commentaire