[sqlite] ORDER BY - Case In-sensitive

Currently a sqlite orders text fields as Case Sensitive =SAMPLE SQL== SELECT * FROM( SELECT 'Apple' AS name UNION SELECT 'apple' AS name UNION SELECT 'Banana' AS name UNION SELECT 'banana' AS name ) ORDER BY name =RESULTS== Apple Banana apple banana Is

Re: [sqlite] Sorting a text field as if it were integer/float

Probably late for this replay, but you can convert a string to an integer by adding a number: SELECT ... ORDER BY (catnum + 0);

Re: [sqlite] SQLite on limited Memory

You meantion avoid using sqlite3_get_table. I've been using sqlite 2.8.15 and have postponed upgrading just because "it's been working". Are there better memory handling and speed improvements for embedded devices in sqlite 3, or are most of the improvements for machines with lots of ram and l

[sqlite] SQLite on limited Memory

I've been developing an app on a linux embedded device with 128 M of RAM, although the available RAM for queries is less than that. Now that the databases are getting a little larger (120 MB), I'm having problems with some queries that have large results. I watch my memory drop completely, an