Reply to thread

hmm... doesn't seem work:

[code]sqlite> select title from application order by title;

Genesis

MAME

SNES

mame dirbrowse

my programs

sqlite> select title from application order by title collate nocase;

Genesis

MAME

SNES

mame dirbrowse

my programs

sqlite> select title from application order by title collate nocase asc;

Genesis

MAME

SNES

mame dirbrowse

my programs[/code]

Do I need to create the table column with some collate parameters?

thanks,

Daniel