See this: http://stackoverflow.com/questions/1188749/how-to-change-the-collation-of-sqlite3-database-to-sort-case-insensitively Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
________________________________ From: [email protected] on behalf of easinewe Sent: Mon 12/13/2010 10:04 AM To: [email protected] Subject: EXTERNAL:[sqlite] Alphabetic Order In my SQLite database file entries with small caps are listed at the end of list after Z. Additionally an entry with multiple caps like NBA appears before something like Natalie. How do I force it to list all these entries in correct alphabetical order? Any assistance would be much appreciated. -- View this message in context: http://old.nabble.com/Alphabetic-Order-tp30446589p30446589.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
