Anony Mous wrote: > In SqLite, LIKE works backwards. It's not case-sensitive, although it > should be.
The SQL standard specifies that LIKE does comparisons using the collation of the string values. SQLite uses NOCASE by default. You could override the like() function (which is what PRAGMA case_sensitive_like does), but it is not possible to get a string's collation from inside a user-defined function. > I suggest ... that SqLite implement: > SIM and ISIM This is too similar to SQL's "SIMILAR TO" operator. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users