On 7/30/07, Chase <[EMAIL PROTECTED]> wrote: > Right now, when i do a select in sqlite that is supposed to be in > alphabetical order, i get: > > DC > Da > De > Do
> We ultimately will be creating an index for this column anyway, so > let's just jump ahead and talk about creating an INDEX which would spit > out: > > Da > DC > De > Do You can use the COLLATE clause when creating the index (or the table column, or with ORDER BY in a query). See http://sqlite.org/datatype3.html#collation for available collations. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------