I have a list of categories I am pulling from a Main Database SQLITE .db. I am having a problem being able to list my categories in ABC order. It shows up like:
- Alpha
- Beta
- Dominos
- Ángela
The accented letter pushes it to the bottom instead of next to its appropriate letter. I have tried COLLATE and LOCALIZED with no success. Using either just breaks my application and does not show any of my categories. SELECT DISTINCT Category FROM 'Main Database' ORDER BY Category
Help on the correct method of pulling this with SQLite would be appreciated. Thanks!
Aucun commentaire:
Enregistrer un commentaire