Case Insensitive Sort with SQLObject

Submitted by jeff on Wed, 01/20/2010 - 19:08.

The key to case-insensitive search is to sort by the lowercase or uppercase of the sorting column.

SELECT * FROM songs ORDER BY lower(name)

from sqlobject.sqlbuilder import func
print list(Songs.select(orderBy=func.lower(Songs.q.name)))


jeff's blog