> On Jan 11, 2017, at 9:55 AM, Anony Mous <fyng...@gmail.com> wrote: > > Textual data has case. Sometimes that matters. Sometimes it doesn't. A > database engine should be able to cleanly deal with that without forcing > the programmer to write custom code.
+1. And while we’re at it, I’d like to see a case-insensitive string equality operator. > SELECT trim(name) FROM names WHERE name LIKE('Ben') and name > ILIKE('benjamin') > > ...you can't do that in SqLite using a pragma, can you? If you can, I'd > sure like to learn how. But to play devil’s advocate, you _can_ do that with: SELECT trim(name) FROM names WHERE name LIKE('Ben') and lower(name) LIKE('benjamin’) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users