谢谢谢 <[EMAIL PROTECTED]> wrote:
i need to select data from my sqlite database and i want the data
should be ordered by a special column;
my searches of the db should not be case_sensitive;
my sql statement is like:
sqlite> select * from customlist order by name;
i found the result is case_sensitive
select * from customlist order by name collate nocase;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
