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: sqlite-users-boun...@sqlite.org on behalf of easinewe Sent: Mon 12/13/2010 10:04 AM To: sqlite-users@sqlite.org 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
