[Tutor] SQLite3 DB Field Alphabetizing
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
> It doesn't really matter(at this point), for my purposes, but I'd
> 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
Did you include an ORDER BY?
Author of the Learn to Program web site
More information about the Tutor