Brass Tilde wrote:
Is there a setting that I can use when opening a database, or when creating
it, or whatever, so that queries against textual fields in the tables are
*not* case sensitive?
You can define a new collating sequence using the sqlite3_create_collation()
API then use that collating sequence in the COLLATE clause of your table
definitions. There is already a built-in NOCASE collation that works for
US-Latin characters. You'll need to do something more advanced for
international characters sets, however. If you need i18n support,
you can still use the built-in NOCASE collation as an implementation
guide (it isn't hard) or to experiment with the COLLATE clause on table
definitions.
The above is for SQLite version 3.0 or greater. If you are using
SQLite version 2.8, the answer to your question is "no".
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
