[Tutor] SQLite3 DB Field Alphabetizing

Alan Gauld alan.gauld at btinternet.com
Tue Oct 12 15:59:25 CEST 2010

"David Hutto" <smokefloat at gmail.com> wrote

> My question is, why is everything except [:-2] in alphabetical 
> order?
> It doesn't really matter(at this point), for my purposes, but I'd 
> like
> to know when they changed the abc's to xy;z's?

Without seeing the SQL we can't be sure.
By default SQL does not guarantee any order.
But if you specify an ORDER BY clause then it should be ordered
as specified.

Did you include an ORDER BY?

Alan Gauld
Author of the Learn to Program web site

More information about the Tutor mailing list