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