By default (that os unless specified otherwise) the collation sequence for comparisons and indexes is BINARY. The only time "abc def" and "abc DEF" compare equal in either an index or a direct comparison is if COLLATE NOCASE has been specified -- the default is case and accent sensitive.
Sent from Samsung Mobile -------- Original message -------- From: Simon Slavin <[email protected]> Date: To: General Discussion of SQLite Database <[email protected]> Subject: Re: [sqlite] Trigger question _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
